The Greenville native who steered Alabama's high school athletics since 2021 is stepping down in September