Now, some scientists — emphasis on “some” — do not like religion and are militant atheists. But many scientists are believers. So, again, there is no inherent all-or-nothing opposition between the systems.
Science wants to study the material world. And who would oppose that?
People of faith want to contemplate the immaterial world — but they may also be very interested in the physical world (we live here, you know). The history of science is largely the history of the Christians studying God's creation.
Lastly, if the show “Cosmos” simply wanted to talk about the physical world, and the current thinking of scientists about material things, that could be done in a pretty neutral way. Just stay focused. But they don't do that — they go out of their way to bring in the topic of believers and criticize them. And why? It's really unnecessary. But they cannot help themselves, because they feel threatened by people who engage in independent thought. Yes! If someone does not accept current scientific dogma, and if someone believes that something exists beyond the physical world, some scientists are very threatened by that. So they mock the believers. Meanwhile, people of faith are far more broad-minded. We accept both the physical world and the spiritual world and we have no need to discount half of that and say “There's just nothing there”.
You really will not find Christians who say "Science does not exist" but you will find some scientists who will say "God does not exist". They think they have proven a negative and their closed minds will not accept the idea that there is more to life than atoms.
I specifically identified what that inherent opposition was. I don't think it's necessary to post it again. If you think it's wrong you should explain how that is so.