He might be an Aspie, this kid. My oldest is, and was TERRIBLE at team sports (I remember him on the soccer field lost in thought and getting hit in the head with the ball). What was really GREAT for him was karate. Discipline, not competing against others but just trying to improve yourself, acquiring self-defense skills, overcoming obstacles. He eventually became a black belt. Was he the best at karate? No. But he enjoyed it, and when he was bullied in high school, he had the confidence to know he could take out his bullies if they touched him, and the discipline not to do it.
He also learned to ski with us on family ski vacations and although it as never his favorite thing, he got good enough to enjoy it (he'd usually just ski for half a day) and compared to the rest of his Aspie friends he felt like a jock
It's a very fine line with a kid like this. It's counter-productive to push too hard, but if he can gain some skills and confidence like my son did in karate, it can be a very good thing.