A short story to get to the point:
Had a son that was little brother of a ballplayer and ate, slept and drank baseball. At 9 years old he was incredibly polished for his age, great sense for the game, great hand eye coordination and was a completely dominant batter, baserunner and middle infielder.
He was one of the best 5 players in VA at his age. A lot of parents complimented me on his skill and one asked what I thought his future was...I told him zero in baseball. He was thunderstuck and asked why I said that and I told him 5'7" and 140 lbs. His face was confused - my son had broken a leg at 2 years old and the DR told us his bone structure was going to allow him to be 5'7 and it was clear he was slight of build was going to be 140 or 150.
Time came to try out for JV as 8th grader and older son was a starter as a sophomore on a team that was top 30 in US in several ratings services. Coattails worked and younger boy snuck in the back door to power house program. He battled like he always did but no matter how hard he tried the big field and bigger players swallowed him up.
It got so bad that at one game when he was warming up the left fielder between innings a nice grandmother type said...oh look at that little boy on the field - he should be careful. My son heard it looked over his shoulder to see who said it ...and he was on the brink of tears. Even my protective wife in mama bear mode piping up that he was a player felt weak.
He stuck it out for two years but finally he came to me and said - I want to play lacrosse. He was very nervous about it....but all I said to him....play as hard as you can. He was visibly relieved I was not disappointed ....so there is your answer...support whatever he chooses and demand full effort - whatever it is. That goes for a lot more than baseball.