BBC Radio4 had an item on spirituality in old age in (22 March). There were contributions from various people who found consolation in religion and also an interesting piece from Alan Smith. He was previously a lay preacher and RE teacher who had a “negative conversion” experience which led him to become an atheist.
In my case it took much longer to reach this state, but I agree with Professor Coleman’s comment in the programme: firm disbelief or firm belief are psychologically better than uncertain dithering. I’ve long found that the less I’m circumscribed by belief, the better I feel. But I think I’m unusual in this; most people seem to feel better for having the support of a belief system.