After watching my wife's cousins (who had kids earlier) revolve their lives and finances around youth sports for 15 years, and wind up with no scholarships and nothing to show but maybe a little college play time for one of six kids, we opted out of that regime.
One of my kids loves her sports, but it didn't cost anything, screw up academics, family vacations, activities, etc.
I considered an exception for one case... girls, in certain sports, can get essentially guaranteed scholarships if they know how to play. That's due to Title 9 optics, which pushes schools to have equivalent girls teams which can be hard to staff in some sports. That's a reasonable option if you need/want a scholarship. Pro Tip: Girl's soccer is not one of those sports, if your girl has college potential in soccer, you'll know it before age ten.