As a long-time (decades) Houston area resident, I would suggest that for the wedding you fly in and out on the same day.
Satisfy your road trip desires by going somewhere more pleasant such as Grand Canyon, Yellowstone, even New York City, but not Houston.
And please don't believe anything coming from other Houstonians reported on this thread. Those folks are simply suffering from heatstroke. My proof is all that talk about Whataburger.
(Historical note: I was married in Houston more than 30 years ago.)