I was 10 in 1969. Landing on the moon was a communal and shared event for a large percentage of the population, via one of the three television networks. As was the war in Vietnam.
Many decades later, our institutions are in need of rebuild, for the common good. Maybe this event is a "small step" in that direction.
The Apollo program only barely reached 50% approval during the Apollo 11 landing. They canceled landings because people stopped caring within a couple moon landings.
The popularity of Apollo is fictional. Artemis has dramatically better popularity than Apollo.
I"m not saying it had high approval. I'm saying it had high community awareness, unlike the current mission. I was in a bookstore where they were playing the radio over their speakers as Apollo 13 reported problems. That seems different to our current fragmented, de-institutionalized world, FWIW. Maybe there are tiktok memes that I'm not aware of.