No one is watching superhero movies and abandoning their aspirations and ideals hoping they get superpowers. People watch superhero movies because they're entertaining, and because they grew up with the characters in comic book form.
Not true. They might be the biggest genre in terms of revenue, but look at American films released in the last couple of years [0,1] and you'll find the vast majority of them are not superhero movies. And while there is undeniably an insane amount of superhero merchandise out there, there aren't a ton of superhero books (outside of comics,) superhero albums, or even superhero video games either. So they're far from saturating even their own media, much less all media.
[0]https://en.wikipedia.org/wiki/List_of_American_films_of_2020
[1]https://en.wikipedia.org/wiki/List_of_American_films_of_2019
Peter Parker is a science nerd. I'd bet plenty of people grew up to pursue science because they were inspired by the comics.
Also, the people who "grew up dreaming of being Spider-Man" also grew up watching Star Trek, and Star Wars, and probably reading SF novels, maybe playing D&D, etc. This is literally the demographic that was interested in math, science and computers (back when being interesting in computers was 'weird') in school while the "normies" were playing sports and banging cheerleaders and such.
We’ve got the latter, the former was theoretically impossible when it was filmed — yet the impossible was still useful inspiration.
Or that we could be a billionaire that could build a flying armor suit?
Super hero movies are everywhere, to an almost absurd level.
Why self-insert as a traveler in the stars when you can instead self-insert as the all-powerful center of attention?
Makes sense given the rise of social media, too.
Everyone is a YouTuber, live steamer, superhero.