Air travel gets you to a place that you want to go to. Going into space just gets you a pretty view and not much else. To quote Gurtrude Stein: 'there's no there there"
I think you underestimate weightlessness and the possibilities moving and floating in 3 dimensions brings. Space sports could be very different from sports today.
What is the grand canyon other than a pretty view?
With no gravity, aging in space is a different proposition.
Insurance against nuclear and meteor catastrophe on earth is worthwhile, if only as a backup copy of civilization.
Once people start living in space, cultures will fragment and evolve in ways they never have before. Colonies will have their own recipes, foods, traditions, etc. We bring the "there" with us, or create it "there."