Yes, I was one of the ones who stayed up all night to see the Moon landing, with my dad, who was a member of the British Interplanetary Society going back to the mid-fifties. In 1969 we both thought we were all going somewhere, not just the Apollo astronauts, but I guess that didn't happen.
Here's Neil Armstrong just after the EVA. He's 38 years old, he's just got back in after a walk on the Moon, and his thinking is probably somewhere along the lines of the Onion piece (NSFW).
One day they'll have to put guardrails round his footprints up there to stop rubberneckers destroying them, but that may be further in the future than I thought it would be, back then.