Yes and no, I'd say. Going back to the moon is big but it's also pretty self-contained, in a way. It just costs money (and doles a bunch of it out to the contracted companies). It's also mostly time-boxed.
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.