Any athletic parents with unathletic children?

This is tough

We've got 2 wonderful children. A preteen son and an 8 year old daughter. Both are great, kind humans. Our daughter is the athlete & our son is more of an academic. My wife and I were both active and athletic growing up and played most sports imaginable. We've both got competetive dispositions and have always enjoyed training of some kind to kind of set the story and give more context.

Our son is in his 3rd year of basketball and it's just not clicking for him. He likes basketball the most, but he's played multiple sports. So it's not like he hasn't tried different things. I think we're finally realizing that he doesn't enjoy them and as much as it breaks my heart to say, he's just not very good at them. I hate to admit this, but lately it's been a struggle for me to make it through some of his games. There's no passion, desire or heart when he plays. He's timid & plays scared regardless of what sport it is. And he's not a small kid. He's bigger than a lot of the kids he's playing against. He's the opposite of me and his grandfather who were outside playing sports with the neighborhood kids from sun up until sundown and pretty wild.

He had a double header this morning and it was the same performance that he's had all year. Lethargic is a kind way to phrase it. It was to the point my wife went down at half time and talked to him and tried to give him some tough, but encouraging love because I was too frustrated and didn't want to make it worse and I would have. I know myself well enough to know that I wasn't in the right head space to give him the talk like I typically do. I love my son and never tear him down, but we've had some tough, man to man talks about hustle, playing brave, want to, team work, etc. the same way that most fathers do with their boys as they try and guide them while they grow.

I'm struggling though and it's starting to hit me that he just doesn't have the same disposition as the older guys in his family. I love him more than anything on the planet, but he just doesn't have that spark that you're either born with or your not. Has anybody else experienced this? I'd love some advice on navigating this because it's kicking my arse.