Many people forget that something other than the Cold War was partly responsible for getting to the moon. At the time the decisions were made the people in power had lived through one of the most amazing eras of technology growth there has ever been. Many could remember seeing the first automobiles in their community, and the first airplane. They had watched cars change from cranky (literally) open air jitneys that were barely better than horses to comfortable, fast, air conditioned creations. The had watched airplanes make the same sort of transition, and watched speed barriers fall at every moment. They had watched nuclear power transformed from a science fiction dream into something that promised to power much of the country and let military vessels run for years without refueling. They had watched the diseases that killed their brothers and sisters in childhood driven into retreat. It was easy to believe that anything was possible.
It was also an era when experts predicting what was possible and impossible had been proved wrong often and in compelling ways.
The media and public had also bought into this expansive view of the future when anything not only was possible, it was likely.
The only comparable technical change that has occurred in the fifty years since is the microelectronics revolution. Which when you get right down to it isn't all that exciting. You can replace stop motion animation, be bugged on the phone at all hours, and type your own documents instead of having a professional do it. You can listen to music in your car and watch TV at home in higher and higher resolution so you can see a higher percentage of advertisements done in higher resolution.
So part of the answer about how to get a buzz about spaceflight is to get optimism about the future back into the zeitgeist. In Vacuo Veritas perfectly embodies much of the public. Everything is too hard, too expensive. We must save our limited resources to continue doing what we are doing now. Get off my lawn, dammit!
A physics breakthrough showing that the laws of physics known today aren't the whole story, or just a new breed of media writer might do the trick.