Not sure if it is what your son is looking for, but University of North Alabama has an Earth Systems Sustainability major(I believe that is what my son’s roommate is majoring in). They currently offer in-state tuition for any student receiving an institutional scholarship of at least $250 and the current chart shows an award of $9,000 plus housing for your son’s stats. They also have other scholarships that you can apply for such as leadership. If accepted to honors college that offers a small scholarship. The $9,000 covers most of in-state tuition leaving fees and meal plan.
It is within a mile or two of the Tennessee River as well as many lakes. It’s not too far to trails and hiking.