As a species, we aren't going to spread out there.

Well not with that attitude!

Yeah, space is hard and yeah mistakes have been made along the way. But things are definitely changing. Reusable rockets are nearly here... Between spaceX, rocket lab and stoke aerospace, there is real potential for these rockets to work. Hell, SpaceX has already conducted a successful orbital test flight.

With reusable rockets we'll start to see a drastic reduction in the cost to get to orbit, probably by two orders of magnitude, but possibly even more. With the cost down people will reassess the value of space and the resources available there. In other words, people will start doing more in space, and getting more from space. Resource collection, refining and specialized manufacturing are three most likely industries to start expanding into space. Once there is work to be done there it will begin to make sense for people to live there.

As a species, we aren't going to spread out there.

Not today, no. But within my lifetime, I expect we will. Remember, change is usually slow and this would constitute the most profound change in human history.