I grew up in Texas, people are have been building in literal floodplains because there is no more room to build.
https://abc13.com/floodplain-housing-building-houston-flood/...
Houston is just second-to-last in line in Texas to face the affordability crisis (followed by San Antonio) because they have the highest capacity automobile infrastructure, but it's already regularly ranked with the worst traffic in the United States.
While I agree that Houston does a lot of things right, especially just literally allowing density, I do not think they would survive an influx of folks while maintaining affordability any better than Austin has.