We've established what you want him to play, but have you sat down with him and asked what he wants to play? I mean REALLY ask...not ask, but essentially tell him what he wants to do (as my Dad used to do with some things). My $.02...ask him if he would rather try playing something else. If you word it like that, he's not going to feel like he's obligated to not disappoint you. Don't come at him like.... "Don't you want to play football son?"
You should be more concerned with his development and keeping him active in ANY sport than you should be about how it makes you look with his Mom or the courts. I'm not sure why that's even a concern for you at this point. So you withdraw him from football and put him in basketball (or whatever)...WGAF?
All that says (to me) is that you care enough about what your child wants to do that you listened to him (whether he keeps playing or not). If he wants to play football...great...but don't be that Dad that keeps their kid in a sport just because they want to live vicariously through his on-field success.
My son likes football but you have to motivate him to stay at it.
Son wants to quit football and mom ain't helping
It doesn't sound like he's THAT into it. He's a kid...if you have to motivate him to keep at a sport...he doesn't like it. Kids should be excited to play a sport. They shouldn't look at it like they're being forced to do chores or homework.