I don’t think a school should ever give up on football unless the numbers aren’t there. It’s the only sports where all segments of students can play.
You use business jargon like investment, return, resources etc. Schools aren’t businesses, they’re schools. If they were businesses not sure there would be any sports.