That's a good, grounded assessment of the scale of the problem. I too believe that the human colonization of space, even near-space (ie within the orbit of the Moon) is a long way off. The energy costs are simply too high and resources too cheap on the Earth to make it viable (in spite of typical SF fodder of asteroid mining). This is a problem because with 6.5 billion people we're using up resources. Fast. Anyway, I…
By the time we acquire the means to leave the solar system society will have transformed so completely that it's impossible to predict what our goals will be. Resources and population are not likely to be problems at all though.