At that point though, there are lots of other romances to peruse. Somebody could go to the moon, but it won't be me. I could however go to my local art museum - at a much smaller costs than my share of sending someone else to the moon, but I'd get more value from my trip to the art museum than someone else on the moon.

Or in my case I just went to my local high school marching band competition, and got to hear some great music. YMMV on what you find more romantic.

People want to go to the moon, you could make your same argument for lots of things humans have done but at the end of the day science is not the reason 99% of people care about or want to colonize space. People have a desire to colonize space