Earlier quoted context omitted.
Manned space flight in generally is a hugely wasteful money sink. It eats up about 50% of NASA's budget, and there's no real reason for it other than "we're putting people into space because we want to put people into space." People vigorously defend these boondoggles, then finally admit they were a huge waste years after the fact (as we've seen with the space shuttle, and as we're now starting to see with the SLS).
Putting a man on the Moon is something many view as humanity's greatest achievement, ever. Even if we ignore absolutely everything else, I think this alone makes it worth it. People need to be inspired. It's the spice of life. But if we look the future, the possibilities are even more enticing. Richard Nixon effectively cancelled human space flight after a series of Moon landings. Had he not, we could very well have…
Sending a huge amount of your budget to send people into space because "people need to be inspired" leans a lot closer to YouTuber than science. You're sacrificing the scientific budget for the sake of giving people a spectacle. This comes at the cost of actual technological advancements. Look at the development costs for Falcon and Falcon Heavy, for example, or Starship, and then look at what NASA's spent on the Space Shuttle, SLS, ISS, etc.
The actual science, as I wrote in another reply, ends up being far less important than how NASA frames it (and often doesn't end up being used at all). And even in those cases, it's not at all clear that humans in space are actually needed to get the job done.