I get both sides of it.
My DB and I weren’t into sports at all. Our DM used to really try to encourage us, but we just weren’t keen. Our DF wasn’t into sports at all, so it was a losing battle for her.
Now, with our kids - DH is really into it. We have basically let them try anything and everything, and then stick with the ones they enjoy. Tennis, football, rugby, floorball, hockey, ballet, jazz dancing, gym, mountain biking, swimming, diving, netball, horse-riding, and I’m sure I’ve forgotten a few over the years. DH’s mantra was - at least one team sport and one individual.
Tennis, hockey, netball and horse-riding have stuck.
My DC are both a lot more confident and outgoing than me, and I know that a lot of that is down to being actively engaged in sport, making friends through teams, being good at some sports, etc. Like it or not, being good at sports does have social caché.
I look back now, and realise why my Mum (who obviously loved her sports growing up) was so keen for us to do it. It is good for kids.
But it’s about finding the right one for them, that they genuinely enjoy, and want to do.
My DC also do music and other cultural things - it’s not all about sports - that’s not healthy when they’re young, either.