Bajorans are kind of the odd man out for discussing religion, despite existing primarily to discuss questions of faith. Their gods are literally real. It's not "science versus religion" when you can scientifically measure Heaven's presence less than a light year away.
The Prophets are some of the weakest gods ever portrayed on TV. Q is more worthy of being called a god, since he is actually far more omnipotent than the pitiful wormhole aliens.