I was eight, and it was awesome. And I don't mean the kind of "awesome" people use these days when they find out the fries don't cost extra; I mean the "inspiring actual jaw-dropping awe" kind we used back then. Scale made no sense; it was huge in ways that rockets (who hasn't fired a rocket of some kind as a kid?) shouldn't be, and your brain told you that it wasn't up to walking speed yet when it cleared the tower, so it was definitely coming back down any second now. Unfortunately, the best I could come up with at the time was "ho... ly... cow!!!"
I'm about your age and, yeah ... at this remove I'd use the word majestic, how the huge Saturn V stack would slowly start climbing and accelerating.
Compared to later programs, there's also a "wow" in that NASA was "going to put some men on the moon", vs. the "space truck" paradigm of the Shuttle and other launches which at best send probes to far off planets and such. A different scale in every way.