Interestingly, his equally-aethiest contemporary Asimov accepted the role of religion in people's lives. I forget which book, but Asimov mentions friendly teasing between himself and a religious friend in one of the prefaces. Something about moving the Bible back out of the Fiction section of his personal library.