Apollo 11 was huge, 12 already got a lot less attention and 13 was pretty much a simmer until things went awry. Within not even a handful of flight, the shining example of human ingenuity had already become mundane for the public at large.
On the other hand, gossip and human stories seems to keep people hooked. Look at the popularity of astronaut videos from ISS, for example.
It is kind of funny that NASA hasn't realized that to get public interested, they only need to drop the dull Earth control center stuff and voiceovers, and have the astronauts speak to the viewers. You know, like Big Brother in space.
Just look at Chris Hadfields videos from ISS (one Youtube playlist
here). Millions of views for every single one.
Set up a moon base, with a big swimming pool for relaxation, and lots of young, fit scientists and astronauts and a live feed to Earth, and you've got a keen audience for sure.