It's true that humanity is less in the game of building pyramids, dramatic edifices of might to be looked upon in wonder, but I suspect much of that was grandstanding in a global cold war, rather than driven by need or even a genuine striving for achievement. Our focus has moved in a more democratic, consumer-oriented place, where it is simultaneously less visible as a monument, but where its leverage, the number of lives it affects, is higher than ever.
Space exploration doesn't make a whole lot of economic sense, until there are resources beyond our planet for which the demand exceeds supply such that the price level justifies the effort. I don't have any romantic fantasies of travelling across the galaxy, much less universe; without FTL technology (which will probably never exist) or greatly lengthened human lifetimes, it isn't realistic to focus on it. If it was really necessary to go to the moon again, I'm confident it could be done much more cheaply and safely than it was last time, but I wouldn't vote for public funds to be spent on it.