Both my sister and I played competitive sports growing up, the kinds where we were attending regional or national tournaments most weekends (driving or getting on airplanes). I was an all-state athlete (Kansas bleh) and got some "offers" to small private schools. My sister was much better and got full ride offers from every top 25 program in the country and tons others. Of course my folks spent a lot of money on both of us, but they viewed it as an investment because we could get our college education paid for. Long story short, I think we both ended up hating playing the actual sports we played. My sister had to go pro in something other than sports and with her shitty free education she has struggled in the real world.
So, parents, just relax. Your kids should learn commitment and teamwork in sports, but it should be fun, and when it stops being fun go do something else.
My (current) theory: I'd like my kids to do some team sports and some individual sports, and then also some activities where success is not objectively measured and the rules not so objectively defined (like fishing, hunting, photography, something like that).