The goal could be simply to learn how to do it again, since almost everyone who actually has done it--on any level, be it engineering, management, manufacturing, flight crew, ground crew, etc--is dead. That's a totally worthwhile exercise if it's actually a serious goal to explore further.

We have plenty of people working on space - we go to Mars with robots all the time which is harder than the moon. We have a space station (though it is nearing end of life). We have all the needed knowledge it is just applied elsewhere. There will be some things to learn about the moon that are different but not much.

Apollo made about a half dozen crewed trips to the moon (quantity deliberately left vague to account for quibbling over technicalities). They made it a relatively reliable, repeatable affair. My point is that organization--the team of people who have done that no longer exists. So until another team starts doing it again, we just don't know. Theoretically it's very probably achievable, but theory absent experiment doesn't really mean anything.

There is value in experience, but for something like this I'm going to submit that the larger value is in learning to spin up teams that do something completely different.

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.

Yea but it is also about opportunity cost. I would love if we can do everything, but we can't. Sure, we can put a man on the moon again, but is the cost that we are not gonna be able to send a probe to Titan? Ultimately it comes down to resource allocation. Is putting the man on the moon for just merely because the people who did it are not around worth the resources? No, not compared to the other things we can do in space. Actually, putting a man on the moon again probably very much robs resources from other project that will actually push novel exploration.

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.