Unfortunately, the number of people that were in favor of the Apollo project, even at the time, was a minority. For a while, even the Vietnam War was more popular.
I'm fully on board with Power to the People. However, I don't expect that will translate to more resources devoted to science, or space exploration. "The people" don't really care for that stuff.
I know that is the popular spin but the space race was extremely popular in its day, and with each launch dominated the print media, LIFE magazine, etc., created heroes, and pulled the world together, if only for a few days. And of course, history has proven that the space race/moon program was a much better way to spend money than in Vietnam.
An “uneducated” electorate might reflect a “People don’t really care for that stuff” reality. And of course that is one of the issues, as politicians seek to take advantage of that lack of even basic scientific understanding within the electorate in order to stay in power, and instead, play up meaningless, emotional/nationalistic issues.
Democracy only works with an educated electorate. Or, if only the educated are allowed to vote. Which was more the norm in the distant past than it is today.
Keep an eye on China, as they are experimenting with state-run Capitalism and an authoritarian but highly educated ruling body. Maybe that will work and maybe not. But “so far” that combination has propelled them up the ladder pretty quickly.
"The best argument against democracy is a five-minute conversation with the average voter" – Winston Churchill.