I am also a parent of a kid who participated with a soccer club team for many years. She is a multi-sport athlete who loved several sports and we found the club experience in soccer actually quite good for her emotional and physical health. I will say that family experience with club sports varies based on the quality of the organization. She also played with her club in falls and her other sport in the spring at high school, so she got to do both. This was fun for her and us.
Assume a kid just wants to get better at some sport. I'm a player development nerd and believe most kids would be better served with 1-1 training with a much lower time investment that just joining a club or travel team. I do 1-1 sessions with players for 30 minutes 2x/week for 6-8 weeks in the fall. Players, of all natural athletic levels, will make about two years of progress compared to just participating on the spring team. That's with one whole hour per week of time invested. I love working with players this way because I am measurable-metric driven, so a kid can see their progress. I'm also a little bit qualitative about it too, because sometimes, the goal is just to build confidence and comfort.
The approach I'm describing looks like lots of hobbies. Imagine a kid wants to learn piano or guitar or drums. It's basically the same abstract approach. Work with an experienced teacher, commit to a regular+reasonable practice schedule, repeat for 6-8 weeks, and see if it fits and feels good.
The social aspect of being a good club or travel team is nuanced, but I will just say that my kid was incredibly well-served by having a good group of friends not connected to her school. And she had a great group of friends in school.
The same could be said for a lot of other subjects too.
Physical activity/sports has far, far more benefits than just team building and scholarships. Given that a lot of the conversation seems to be implicating screentime in the decline, I'd guess that if we swapped 10% of school screen time for 10% more sports, we'd probably have a better outcome as a society.
I say this as someone who has done lots of computers and screentime my entire life, and very little sport.