I'm excited to see that ESA appears to be experimenting with various means to pull the broader public into their projects (like this video, or the super-neat cartoons tailored towards a younger audience: http://www.esa.int/spaceinvideos/Videos/2014/07/RosettaAreWe...). Perhaps we can someday have another big set of space programs that enchant millions and drive young people to dream big; to become the engineers and scientists that we need so dearly.
It is hard to grasp how much of an impact the Apollo program (and the paradoxically symbiotic competing Soviet programs) had on a solid two generations of not only Americans, but on people from all over the world.