I don't think humanity makes it past 300 years. We are too volatile. We are all a bunch of slightly smarter monkeys sitting on world devastating devices at a moments notice. All it's going to take is someone calling Putin's mother a fat bitch and M.A.D. begins.

Assuming we don't kill ourselves first. The natural increase in population and climate change will start to impact both habitable regions as well as crop growth over the next 100+ years. People don't realize that climate change is more than just a "small global temp increase" it can affect local climates significantly more. This will inevitably restrict populations to consolidate and force mass relocation.

Governments are way too slow to adapt to change and getting the entire world on climate focus is never going to happen. We have senators like MTG saying on podcasts that global warming is good because the cold kills people. We just can't fix that level of stupidity.

Personally I don't think other planets will ever realistically be able to be colonized long term. It's doomed to failure from the start. It's too hostile, all it takes is one mistake or one bad actor to destroy an entire colony.

Most people don't even know how to do basic life skill tasks these days like crop growth or hell even cooking for themselves. Once something happens that disrupts/kills a good percentage of the population the economy will inevitably fail from a hard recession. Causing food and transport shortages. Causing more people to die, leading to more economic collapse.

So TLDR my outlook is that humanity is on the brink of extinction by 1000 years. In truth COVID was a real wake up call to how not prepared we really are. COVID wasn't even remotely as deadly as the next thing could be. There were approximately 1.1 million deaths from Covid in the US, a relatively meager amount compared to the total population of 335 million, and we are still feeling the economic effects today and probably will for a long while.