Respect is different than actively participating in leading people back to a time of belief in the supernatural, superstition and ignorance.Picard: "Mister Worf, the Enterprise crew currently includes representatives from thirteen planets. They each have their individual beliefs and values and I respect them all."Why would Picard, a man of science and reason,have anything positive to say about the supernatural, superstition and ignorance? "
Basically that's why.
The Picard we see in that one scene is so very different than the Picard shown in the rest of the series, the compassionate, understanding and diplomatic Picard completely disappears for several seconds.
Again, I note the perjorative words against faith.
Just out of interest and I really don't mean to diverge the thread but it feels on topic. Why is abandoning religion bad?
Trek always seemed to imply that the only reason humans and other Federation members reached the success they did was because of hard work, rationality, and technological advancements.
And implying that humans don't take religion as seriously as they once did.
On the contrary, they reached the success they did by allowing each to make up their own mind about such things.
Phlox once attended services at St Paul's Cathederal (and spoke approvingly about the experience). Kirk, while doing what he had to do to get out of the grip of Apollo, in the end "Would it have hurt us to burn just a few laurel leaves?"
In ST III, he told a scoffing Morrow: "You don't have to believe. I'm not sure I even believe. But if there's a chance that Spock has an eternal soul, then it's my responsibility...as surely as if it were my very own."
As in the above, where he was still respectful of the other side of the question. By the time TNG came around, he was a much more strident humanist/atheist, and it showed through in the writing.You can see some of Gene's softcore humanism in certain episodes.