How did it all start? Landing on the moon. It was like any goal you wish to achieve, you establish a method then you set a date to achieve it. President Kennedy made a promise to us and then he set a date. No date set; no goal to achieve. Is there anyone today with the right stuff? Let's hope so.
Under JFK it was a space race - the goal was to beat the Russians to it, so basically a military operation with no expense spared.
Today, there's no rush to get there, a more limited budget, and a huge focus on astronaut safety that requires alot more engineering and R&D work to keep them safe.
But I do feel your frustration, I vaguely remember Bush Jnr mentioning to return to the moon by 2020? I'm sure every president since has had an ambition to return but realistically those dates keep getting pushed out.
With the introduction of SpaceX, it seems NASA is now freed up in a sense to concentrate on the Artemis program.