I don't think it's about space in general, but rather the vision of making humanity an inter-planetary species (at least that is what Elon Musk talks about a lot). I think the idea of expanding humanity beyond our single planet inspires a lot of people, myself included.
Fundamentally that is how it is different from colonizing the ocean floor.
So for Mars, I don't think merely the opportunities for _any_ innovation, are a convincing enough argument, at least for those investing in Mars. For them the specific innovations around spaceflight and non-earth construction are indeed valuable, because of future expansions into space and first mover benefits, using Mars as a stepping stone.
As for the colony on Mars itself, I speculate that having somewhere outside of existing jurisdictions is also attractive for a lot of people; the new unclaimed West. Some may imagine this to become a scientist utopia, free from the restraining politics of Earth; others might be more cynical.
We will see.
[1] https://www.bbc.com/future/article/20130930-can-we-build-und...