I think the moon shots were less about exploration or scientific research than about American one-upmanship with the Soviets.
That wasn't the feeling at the time we actually did it.
The Soviets were largely failing at
manned space travel,
so we didn't have the sense that we were competing with anyone.
(Soviet successes were more interesting than threatening.)
An interesting thing happened when they first set foot on the moon.....
People around the world were exuberantly saying "We did it!", ie, as
fellow humans, they too felt a sense of accomplishment in putting
their own kind on another world.
And for the disbelievers....yes, it actually happened.
Later on, when I worked in aerospace with many guys who made the
moon trips happened, I glimpsed the monumental size of this effort.
A government which can't even create a reliable health care sign up
system could never maintain a conspiracy of this magnitude.