Unless your concern is nuclear war, it’s absolutely a given that the planet can support great-grandchildren. The question is for how many and at what quality of life.
There are no science-based projections of us not being able to support human life with a population of less than 100 million still in 200 years.