It's not anything for or against GR's humanistic "anti-religious" ST vision.
DS9 needn't be a show pro-religion or anti-religion. Just by acknowledging that religion exists doesn't contradict any GR vision. And the Roddenberry ST future with or without religion generally concerned humans and Earth of the future. DS9 was almost entirely about Bajoran and Klingon and Ferengi and Dominion faiths anyway, outside human religions.