Yes it would be great to visit the moon! Though I think I would be nervous on the shuttle/rocket up!
I have been in zero gravity briefly before while doing aerobatics and it’s quite fun! The pilot took the plane straight up so you felt like a tonne of bricks then down again to cause zero gravity for about 5-10 seconds so I was floating in my seat. I remember the pilot taking his glove off and it was floating in front of me – was amazing!!