We went to the moon because we were afraid of Russian hegemony on Earth. Not sure that's "gee-whiz".
And yet it still serves as a common talking point for inspiration. People did go into the sciences in the past and day dream of all sorts of things because of the Apollo missions. The political realities of the Cold War helped fund the project...sort of like how the fight against terrorism helps fund projects to this day.
I feel like modern science may somehow be restricting or restricted from ground breaking, compelling discoveries.
Like, imagine if the world had a big-budget moonshot research project? Mining and colonizing asteroids, a space elevator, novel thruster technology, colonizing the seas even.