Auburn University has Aerospace and SEC football - Lovliest Village on the Plains and a super friendly and collaborative campus!
Auburn has a great engineering program. 
Keep in mind that large, comprehensive research universities, will met your needs. Schools like UW-Madison, OSU, UF, any of the UC’s, ASU, Auburn, Alabama, UM-TC, etc, all offer a wide range of STEM majors. It doesn’t have to be a school that’s 50%+ STEM.
Auburn, Wisconsin, Alabama, Florida, Minnesota, Ohio State and Texas A&M are not STEM dominate, engineering colleges.
and it’s -10 degrees in Minnesota.
@Greymeer - not sure what your comment means. Auburn has more engineering students enrolled than any of the other disciplines. Wouldn’t that make them STEM dominate?
I don’t think a % is a req’t.
I think the student is simply looking for affordable schools with good Colleges of Engineering.