If space flight is cheap, you're better off sending a far more capable human than a robot, because if you're going to spend $3million for a robot or $5million for a human, the human is going to be more than 40% more effective than a robot. It's a totally different story than when the difference is $12billion or $500billion.
What happens to a human body when it's spent long time in zero-g? I have no idea.
Can humans survive psychologically away from earth? Quite a many of us spend quite a lot of time just watching screens so the tiny boxes of first generation colonists might be livable.
If we belive physiological and psychological survival is feasible, then the only matter left considering I think is acquisition of raw materials and bootstrapping a colony-based industry.
I have no idea of the chemical composition of say, mars, and does is have all of the elements we need for our precious technology. But I would imagine earth is not the only place in the solar system with abundance of the all of the important ones.
This last one is a bit of an unknown to me but otherwise you would need to convince me pretty hard that colonization is not a feasible concept.
At the risk of sounding metaphysical, we are as much a part of the Earth as your kidney is a part of your body. Yes, we probably can take your kidney out and keep it alive via artificial means for a certain period of time (it's just an engineering problem) but it is a rather large leap to do so permanently. It's worth asking whether the effort even makes sense.
For a human baby, the womb is the physiologically most natural growth environment. At birth we are separated from our mothers and the comforting heartbeat fades away to other noises. If I may respond to your methaphysical idea: perhaps earth is the womb of a space faring species, and our offspring will longingly observe it through telescopes like a person always misses her parents. But a longing does not incapacitate us, it merely tints the daily experience with a hint of bittersweet.
But in practice - human space flight at a large scale is a messy subject and like most topics of systemantics it will require endless amount of tinkering to even figure out if the idea is valid.
The point of organized missions to gather data from, say, Mars is that this data will help future human space travel efforts. If we accept that we're not going to do that ever then all the current activities are worthless and we can just stop them right now.
Just as most people can find value in doing things despite knowing that their ultimate life is rather short and finite, it's possible to extract value from doing research without trying to force it to be about a race surviving infinitely long.
200 years ago, there were no UFO beliefs and no "easter bunny" as we know it today, but there were sasquatch legends. The claims are as unsubstantiated today as they were then.
200 years ago some people believed the humanity could one day visit the moon. At the time they had no idea how, but 200 years later we have not only gone to the moon but become bored by it.
But I also don't see why you don't think we could establish a martian colony even with the technology we have today. I suppose I don't know what you mean by "sustainable," and if you mean truly terraforming the whole planet to make it a second earth, you're right that that is still the realm of science fiction.
But you don't need that. All you need is a large climate-controlled enclosure with hydroponic farming equipment. The martian atmosphere contains enough oxygen (0.14%) to keep this enclosure supplied, and water exists on mars, certainly in solid form. Such an enclosure would be sufficient for a person to live an entire lifetime without assistance from earth, which is a reasonable criteria for sustainability. The project would be economically possible, but probably politically impractical.
No actual people have gone to Mars because its prohibitively expensive but also so incredibly unbelievably hard technically it will never happen.
Also undesirable. Why the heck would we want to colonise Mars? It's a desert where we can't live without life support. It's just sci fi to imagine we can or that it would be of value or sustainable. Earth is our home and will be forever.
E.g. the first watches that could keep time to assist in measurement of the longitude were incredibly expensive https://en.wikipedia.org/wiki/John_Harrison.
I know historical arguments are usually kinda weak but objectively - space flight is still a young discipline.
I hope you respect that in historical perspective "we've never done it and so won't ever do it" is really weak. It will require empirical testing to figure out if spacefaring human civilization is a tenable concept. Large system cannot be reasoned with beforehand (well, if there are deep physical principles that are obvious then, yeah, sure, but at this point the problem space appears like more like a complex expensive mess of many uknowns rather than a physical impossibility).
At the end of the day, space is R&D. We can develop (and have developed) wonderful robotic missions and we should absolutely continue to do so. But we owe it to the world and ourselves to continue to research safer and cheaper ways to get humans to space. Eventually, there will be cities up there, and a trip to the moon or an orbital station will be just a bit more complex than a flight from London to Tokyo. But it's not going to happen without the necessary hard work and financial investment up front.
Also worth noting -- if we (U.S.) don't do it, China is still planning to put humans on the moon. We can watch and admire, or we can be in the race. Which would you rather?
The moon problem I see is, what happens when a private company decides to make a profit off of the resources there? Pretty sure every government is going to scream bloody murder all the while trying to do the same but expecting their stance; as governments; to be more important. Should be an interesting time for rights when that occurs