Sorry for the REM reference
The Soviets took a pragmatic approach: near earth orbits are great for science, there's nothing on the moon. So did the Europeans for that matter - manned space flight is like getting a taxi down to the shops. We might make Mars but that's as far as it goes, so let's put our energy into satellites, telescopes and probes.
And yet - the romance lingers, perhaps even intensified by the failure of our space race. Once the cold war ended, it turned out that the motivation (and money) dissipated. Instead, we're in the post-space age. Will our grandchildren remember that men walked on the moon? Will they have the energy to care, inbetween long treks for water and trying to eke out a subsistence living on a ruined earth? Perhaps the dominant mode will be anger, at the waste of multiple billions on a giant penis when millions of people starved.
Perhaps, though, the dominant mood will be melancholy. J. G. Ballard's Hello America and Myths of the Near Future depict a California and Florida of abandoned space centres, emptied pools, men and women spiritually hollowed out by the loss of technological purpose.