I think i Kinda agree with Redshirt. The various aspects should be explored, but not to deeply.
For example, it should be accepted that the Bajorans all believe in the prophets - they are a deeply religous race - not an episode of ds9 would go by where you would not see some aspect of their religous beliefs - so this should be explored.
Same with the Klingons - they believe in stovokor and grether and have an honour based religion which was regularly seen on the screen - again this should be explored.
On the flip side, you never saw people from starfleet going around and saying "hey im a christian" or "hey im an islamist" - so this should be reflected as well, and it s hould be accept that in STO, humans follow one religion or more likely, do not f ollow a religion at all.
Same goes for the Romulans, Cardassians, etc - but that said, that aspect of these races was never really explored so who knows.
I just think it should reflect what we saw on the screen.