There are second, third, etc order effects to things like a space race.
There are second, third, etc order effects to things like a space race.
IF you were talking about building a good public transit system the value is in building a team and keeping it running. However this is - for all we know - just a one off show and so there isn't value in getting experience. The people looking at Mars have value in experience, and there may be value in robotic moon missions, but so far as I can tell human missions are just for showing off and should be treated like a one time show off and then get rid of the team for another 50 years.
Unfortunately it feels more like the drive to return to the moon is just a way for the high school quarter back to relive his glory days, as the stereotype goes and is actually less about accomplishing something meaningful to push science and understanding. Tons of things we could do to push science and understanding that is novel that we may forgo to relive former glory.
Healthcare, worker's rights, voting rights, infrastructure, etc, are all more important (so I agree with you there), but also all have way more consequences that are wider-ranging and longer-term (which I'd say contributes do the political dysfunction around those topics).
This should be an "easy win" by comparison, and the "PR" impact of success (or failure) will be significant.
Edit: that said, if you gave me a magic wand to pick any one of these topics for the US to succeed at, it wouldn't be going to the moon.
Could we get the same ends via something more useful? In theory, sure, but it seems pretty evident that the answer in practice is no, since our congress has mostly been gridlocked for the past 16 years.
The matter of factness of the shuttle shows how good the program was, but we still had two explode completely.
NASA literally had departments and budgets dedicated to miniaturization.
Sure, this would likely have happend anyway, but possibly later with all related knock off effects.
What are we missing because they did that though? Or what came latter? There is no way to answer this. It is easy to see what happened because of effort, but not what you didn't get (or got latter) because to focused on something else.