I lived in San Antonio for 4 years and also worked (commuted to) at the Johnson Space Center during that time (SkyLab Era)...don't ask...

..its classified...
You are right... nothings close in Texas... but it is only a hop, skip,rest stop and a jump on the Interstate from Houston to San Antone. The Alamo is off the River Walk in downtown San Antonio. Public transportation is abundant and relatively cheap.A day ,or beter still a night, on the River walk alone is worth the trip.
If Budda95 ,you really are military or ex-military the area abounds with military folk and bases. You should have no problem with finding helping hands to get you around.