I "retired" from Maxwell about a year and a half ago. It's a "college" base (Air University), and officer-heavy as far as rank structure. The base itself isn't too bad; they are in the middle of a minor mission change. The Air Force Reserve (AFR) unit there is transitioning from C-130s fixed wing aircraft to MH-139 rotary wing aircraft, and the first helicopters have already arrived. More projects to accommodate them are coming. Unfortunately, Maxwell is situated on the sketchy side of "Monthuggery", so if he is going to live off base, Prattville or Millbrook (to the north) would be good locations to live. COL for the area isn't too bad, when compared to other states. Sales tax averages around 10% for the area.
There's a Bass Pro in Prattville, and they can probably give good info on hunting / fishing opportunities.
What will your son be doing?