I haven't read this thread, but the answer is this: GR was an atheist. He thought that "evolved humans" would have no need for religion. That's the long and the short of it.
The fact that there is a chapel on the Enterprise is easily explained away and I'm sure it has been discussed to death in this thread and elsewhere.