Even though you could question the whole Artemis concept, it's still extremely exciting watching the countdown with my son. I just missed the original Apollo flights and had assumed I would never see a moon landing in my lifetime. We may well not have a landing for quite some time yet, but it's still cool to see a Moon bound rocket standing on the launchpad...
I don't know if it's feasible for you, but if you can, try to take your kid to see a live rocket launch. The TV is grossly unable to display how awesome these things are in person.
It's even more exciting when you realize that the last crewed mission beyond Low Earth Orbit was 1972 and each person on that spacecraft today are younger than that.
Its going to be a first for me and my son as well. Looking forward to tonight to make an even over it.
We lived ~60 miles North of the Cape when I was a young boy, and watching the Saturn V's go on the way to the moon was a forming experience.