As a life long athlete and endurance coach (and parent of college and high school athletes), I suspect the majority of the parents driving their kids to the ground are not serious athletes themselves. Once you have the experience and knowledge, you are smart about the approach to your children’s sport “career” and know that 2 things are key: (1) don’t specialize early- which I know is a hard sell these days; and (2) there is no such thing as an elite athlete at age 8, 10 or 12, so let them have fun first.
I also believe certain people are better suited for certain sports. But if you specialize too early, you never get to find out, and no amount of private coaching will get them to their full potential if they are in the “wrong” sport. It’s tricky because often times they can get “good enough” in the sport that isn’t a perfect match. I have 2 swimmers but know that one is a much more talented land athlete - and my bet is that that child will change sports later in life.