I was 29 years old, a senior in law school, married with a two-year-old son. And yes, it was exciting to an adult as well as to a school kid.
I was 40 years old and we got out 5 year old daughter out of bed to watch it. She really did not seem that thrilled although her silly daddy was telling her that she was watching history in the making and that she would be able to tell her grand children in after-times that she saw the first landing on the moon.
She remembers the time but not much about the fuzzy b/w pictures.