why look for habitual land in out of space when there if perfectly good habitual land on earth. so lets just take that land.
We have a range of materials on earth which are known. We use many of them. Even the unlimited ones are finite in quantity and their applications.
The universe has potentially many new things that could be better, or just change the way we do things from purely a meterial standpoint. Metals are common right now but what other materials might exist that could completely replace them?
These are things of why we should explore space, and know if it's worth moving away from this home planet.
Plus lets say you're right: wouldn't it be better if the science is behind you and we say "There's no chance of moving off this planet ever because the closest planet which could sustain us doesn't exist" then i think we could make a judement based on information rather than one based on well it costs too much to move off. It only costs too much if it doesn't give some kind of net reward. But you can't know that until you explore what else is out there.