Obviously if you were to rent a vehicle out of Denver let's say, it would be 4WD.
In College Station, there's going to be very limited availability of anything.
You'll have a better selection at a large airport like IAH but, the rental car places are still struggling to recover from the scamdemic. I've had a couple of times in the past 2 months where I couldn't even rent a car with National and I have status there. I wound up having to rent from Avis where I'm just a regular member.
It's going to cost an arm and a leg to reserve a 4WD or AWD SUV but if you take it for 7 days and get a weekly rate, it might not be so bad.
Long story short, I recommend joining a frequent renter program from National and/or AVIS and make your reservation out of IAH, HOU, AUS or even DFW. Unfortunately you'll have to pay more in taxes and stadium fees in a major city but, you have a better chance of availability there.
If you want to fly into Los Angeles, I'd be happy to loan you my 4WD Ford Expedition.