No, but you shouldn't discount the power of scientific materialisim, either. It presents us with an altnernative mythology that is continually defeating traditional religion. It's narrative form, like religion's, is the epic: evolution of the universe from the big bang, origin of elements and stars and planets, down to the beginnings of the evolution of life on earth, for example.
More importantly we have come to a time in the history of biology when religion itself is subject to the explanations of natural science, and sociobiology can account for the very origin of mythology by the principle of natural selection acting on the genetically evolving material structures of the human brain. (I am riffing on thoughts by Edward O. Wilson from his book On Human Nature).
If this is correct, then eventually scientific naturalism, using its capacity to explain traditional releigion (its cheif competitor) as a wholly natural phenomenon, will spell the end of theology as an independent intellectual exercise. But that won't stop religion! That will go on for a long time as a vital force, because the spiritual weakness of scientific naturalism has no such primal source of power. It can explain the biological sources of religious emotional strenght, but it can't draw on them -- because the evolution epic denies immortality to the individual and suggests only an existential meaning for our species.
Humanists and atheists won't ever enjoy the hot pleasures of spiritual conversion and self-surrender. Even though, for all the important we give the idea, nobody can actually explain what the dickens "spirituality" really is. So for those who think it's something, religion will always be meaningful, and who cares about theology. For those who suppose that real "spirituality" is about understanding our connection to "all that is," without supposing that includes being able to continue beyond our natural deaths, religion will still never have any real meaning.