This is why I like to draw a distinction between space exploration and space colonization. The former is definitely within the realm of possibility, using existing technology (never mind the Superheavy/Starship system).

But Musk, with his talk of a self-sufficient city, is clearly targeting the latter, and there are a whole lot of details we haven't worked out.