The anti-medical dogma of Christian Science led my father to an agonising death. Now the church itself is in decline – and it can't happen fast enough. By Caroline Fraser