As a result a space race with the Soviets developed, resulting in the USA winning & Soviets loosing - at a price. The Apollo hardware was a racing hardware, like a race car, build to win a race and little more. As a result, the whole program was horrendously expensive to run & it was politically unworkable to continue running it once a victory in the space race has been achieved.
There was no shortage of people calling to continue not just with Moon but space exploration & industrialization in general (with a good example being Gerard O'Neill - https://en.wikipedia.org/wiki/Gerard_K._O%27Neill#Space_colo...). But they could never get the beancounters & shortsighted politicians to allocate the necessary costs to get things going.
What I think changed is both the technology finally getting cheap enough that more entities can finally get involved without begging a government for a massive budget, because launcher reuse was demonstrated and even just because a bunch of very rich people who like space got involved & can do it themselves without depending on others.
I've put a couple of resources here for you. The first one described the program from a neutral perspective (in line with what you ask - grounded POV to satisfy paranoia): https://bigthink.com/starts-with-a-bang/moon-landing/
This one is for people a little further down the conspiracy pipeline, and it debunks the various things that moon landing conspiracists like to talk about: https://www.iop.org/explore-physics/moon/how-do-we-know-we-w...
Both are worth a read!
Finally this is an excellent jumping-off point to understand the Apollo program in more detail, once you're satisfied that it did happen (if you don't think so, you'll reject the source out of hand.) https://www.nasa.gov/the-apollo-program/
The program itself was really, really, really cool and is worth reading about. A truly enormous achievement involving millions of people and an entire country's scientific and engineering capacity.
I've listened through those flights few times and it still each time takes me back to memories still giving me goosebumps. Especially Apollo 11 when I was nine year old kid listening tiny battery radio all nights at our summer cottage attic.
It is a fantastic site.
We haven't gone again since because there's not much point to it. The US spent an amount of money equivalent to about 10 Manhattan Projects to ultimately put a dozen people on the moon for a cumulative total of somewhat less than one person-month. There was no military utility to it, no commercial benefit, just some science and exploration. Once you've done that a few times, what's the impetus to continue?
The technology was so bleeding-edge that each mission required a huge amount of bespoke manufacturing that got thrown away after a single use, and massive teams of people to run everything, such that each individual mission still cost billions of inflation-adjusted dollars. The American public's stomach for spending such vast sums of money just didn't last. Imagine if you needed to build and throw away an entire Airbus A380 to reach the summit of Mt. Everest. Maybe it would have been summited a few times to show it could be done, but we probably wouldn't keep doing it.
The resolution is to realize that Apollo was a dead-end stunt, not some universe-altering historical event. The lack of consequences was an inevitable result of the structure of what Apollo was.
Then all that went out the airlock & the whole thing devolved into a long-term unsustainable race. :P
It ended up that the government-contractor axis wasn't able to reduce launch costs, not due to technical reason, but political and institutional ones. There had to be a different approach, as pursued by SpaceX.
But then as time pressure set in & money was suddenly not a problem, all that went to the wayside. And by the time Apollo was over, it seems the mindset that rockets are expensive and expandable set in. If it was just inertia or also business interests of the by then entrenched launcher contractors is hard to tell.