I have been told that schools don’t like low grades and high scores. To them it indicates that you aren’t a disciplined student and that won’t do well at elite schools. So, you need to address the grade discrepancy.
How well do you play football? Frankly the number of hours you put in is far less important than how good you are. If you will make varsity as a 9th grader then I’d say get in touch with the coaches and that could give you a solid chance.
Imo your essays need to be excellent and compelling to make up for the grades.