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.