Many believe money would be better spent elsewhere but even non-believers should be able to appreciate the value of a place of solace in a bewildering world, writes Stephen L Carter