Your social circle may have been different, but that says more about them than the 90’s.
I believe eventually we will be on the moon again, and on Mars, but it will require a lot more technical progress before the cost-benefit analysis makes sense. Or maybe all we need is a second cold war, with murderous dictators propped up around the world, CIA toppling governments, proxy wars killing millions, that kind of thing. Choose your pick.
Figuring out how to live on Mars mostly involves solving Mars specific problems. It’s close enough to the sun you can just use solar panels, enough gravity to avoid most zero g problems, there’s an actual atmosphere to extract oxygen and carbon from, minimal need for deltaV, etc etc.
I’m all for learning to mine asteroids and actually live in space, but Mars is a literal and figurative dead end.
Mars has nothing to offer humanity as a place to live - you would be better off living on a ship on the ocean if you truly want to get away from people - but it would be nice to check it off our collective bucket list.
I’m curious about the sociological forces that have made this sentiment common. In the 1990s, people would talk about going to Mars and the “why” question wouldn’t even come up. Obviously it’s the next milestone of human civilization.