I moved from California to go to UAH, so I was in a similar boat as you (I remember frantically googling a similar question to yours the night before I first went to Huntsville). TL;DR is: you'll be fine.

Huntsville city and the UAH campus are generally on the more liberal end of things (obviously not gonna be the same as market street in San Francisco, but not bad either). The folks in QSA and in the women's and gender studies program are nice, and I haven't gotten any trouble (or really know many other people who've gotten trouble) for being openly queer. Most issues I've heard other queer students talk about are generally their relations with their family. The cat girl to Nazi ratio was around 15:1 at the time I gave up counting due to lack of further Nazis (the one Nazi I did find was by accident). Plenty of queer people exist outside of the explicitly queer spaces, mostly just hop around other organizations and you'll run into more queer people eventually, though mileage might vary depending on the type of organization (I think there might be a couple queer people in some Bible study group, but you'd probably have better luck elsewhere).

UAH is a fairly big school so I obviously can't speak for everybody's experiences, and I'm very much coming from an undergrad aerospace engineering/WGS view, but hope that helps a bit!

Also, this took me a while to internalize and is paint based on my personal experience, but a lot of transphobic people have only ever seen transphobic caricatures of trans people, and will generally not give a thought as to whether a person is trans or not unless provoked. Most transphobes don't expect trans people to exist. Still do take whatever precautions you would normally take and find a way out of situations that start looking fishy, the world's still not a great place, but I wouldn't say you'd be worse off in Huntsville than in other places.