Perhaps this is an impossible task. Humans don’t care about space explorers. We continue to have fun with sci-fi, but when we actual humans going to space in real life, it turns out they are just rich ass-holes that we all commonly hate.
Compare this with actual useful robotic missions like the James Webb Space telescope, which sparked huge interests and a ton of excitement.
I think the era of human space exploration died in the 1970s, and any effort to try to revive it are futile.