The space program was a lot of fun when I was a kid in the 1960s, but it turned out we were all dressed up in our spacesuits with no particular place to go. The rest of the solar system just isn't very habitable. Venus isn't like the Congo and Mars isn't like Bolivia, the way Heinlein hoped they would be back in the 1950s.
Various Presidents have enunciated various space program goals in recent decades, but not much gets done because it's hard to figure out why we want to spend vast amounts of money to go there.
So, here's a space program goal where we are currently making progress and could actually accomplish within a few decades:
Discover human-habitable planets around other stars.