The short answer is that those were conceived during economic boom times before the median American was sold down the river with outsourcing, financialization, and good old fashion corruption. 50 years after this crime was commited against the people, the ideals espoused in those fictions has become hollow and sour.

Neither Star Trek nor the Apollo program were popular at the time. The original Star Trek was cancelled after three seasons with no further content produced until a movie revival a decade later; contemporary polls of the Apollo program consistently showed that most people thought it was a waste of money. If (if) SpaceX and Tesla deliver on Musk's dreams, I expect people in the 2050s will wax nostalgic about the 2020s and complain that we can't summon the same spirit of adventure for the Dyson spheres Claude wants to build.

Selling out all of our values to make an extra buck.

Star Trek is fiction, a hopeful vision of a far future and not a description of the present. ToS was also dark and verging on a horror series most of the time. The rampant optimism of the 1990's and TnG are NOT found in ToS. The Federation of ToS isn't a utopia or implied to be one, it's just more egalitarian than the present at the time which was defined by generational, racial, and economic fighting. It took place during the context of a war that claimed tens of thousands of American lives, most drafted from the ranks of our youth.

It's very easy to imagine a past defined by fictional narratives and idealized memories of the Cold War. Don't give in to nostalgia, it's a lie.