No thinking person can believe in religion
I think that's simply false. Some of the most intelligent, thoughtful, humane and compassionate people that I've ever met were religious in some fundamental sense. My thesis advisor in graduate school was a former Catholic priest with a Doctor of Sacred Theology from Georgetown. I might come close to being a "believer in religion" myself, according to some definitions at least. I'm agnostic (and effectively atheist) about gods, but I've been paying quite a bit of attention to Theravada Buddhism lately as a form of spiritual psychology.
those who do are under delusion and science is slowly lifting that curtain of nonsensical personal beliefs.
Science is very good at revealing the regularities in how physical events correlate with other physical events. But it's not as effective at accounting for the observed regularities and for being itself in the first place.
And as others have already noted, science provides us little help in making our individual lives and the universe around us seem meaningful. Science doesn't speak to the emotional side of human beings in the same way that religion does.
Religion will die out soon
I think that religion will be with us for the forseeable future. What we are likely to see are greater or lesser changes in the forms that religion takes, as it evolves, adapting itself to changed cultural conditions.
We will probably continue to see the emergence of new atheist religions.
Marxism is/was the most prominent example of that breed so far, wrapping itself in the prestige of science while still purporting to give history a broader eschatological meaning. Marxism was basically a reworking of apocalyptic Judaism, with God and the supernatural removed, but still offering humanity hope for a paradisical classless Kingdom at the end of time, with the proletariat and its vanguard party taking the place of the heavenly Messiah with his avenging revolutionary sword.
Politics in general has taken on increasingly strong religious overtones, with party adherence and hostility towards political opponents taking the place of the violent religious anagonisms of past centuries. It used to be Protestants vs Catholics, now it's Left vs Right, Blue vs Red.
The flying saucer faith still has potential, transforming heavenly visitations by supernatural angels and demons into heavenly visitations by ostensibly 'scientific' space aliens. And as the myth evolves in a conspiratorial direction, with alien influence over earthly governments and massive coverups, it has potential to give history entirely new meanings.
Psychology has clear religious overtones, providing modern men and women with newly secularized paths of contemplative inner self transformation. Fear, doubt and anxiety are reconceived as if they were medical diseases and the psychologist lines up alongside the physician promising to cure them. The white coat of the clinician replaces the Buddhist monk's ochre robe.
And on and on. It's everywhere. Religion isn't going away so much as its being redefined and reconfigured.