You’ve made some interesting points. Of course I’m saying that we are moving to something closer to a pre-eschatological form that explained relationships and things without emphasis on death and fantasy assumptions of another world. The origins of religion didn’t start out with that. My point is that we need spiritual knowledge tools that link naturally to a scientifically understood universe. This is inevitable because reality is much more amazing than imagination yet imagination is needed to build on knowledge and reality to form new theoretical ideas.
What I’m suggesting is really the mystery knowledge traditions that focus on learning the techniques to learn. That’s a bit of reach but it’s about the only place I could find to merge prophets like Jesus and Siddhartha and Mohamed back together to make them at least moderately relevant again.
But I suspect you are correct that these will be replaced by new prophets but not religious ones. These are already here or have already passed into sainthood: Sagan, Feynman, and now Kurzweil and maybe even Neil deGrasse Tyson.