Where to begin?
I grew up in a smaller town in Northern California and played growing up. It was essentially "grassroots" and those of us that took it seriously ended up playing on the High School team. We played in what we called "winter league", travelling 1-2 hours each weekend in the high school off-season. That would be considered a rec league today - one game a weekend, not weekend-long tournaments.
My kids played AYSO, and frankly I think AYSO is its own worst enemy. As I recall it was that way when I was growing up too. My home town kicked them out in fact. A parent started the grass-roots recreational league that plays to this day in that town. AYSO siphons off money and the best players to support more competitive teams that act more like club teams, playing in weekend long tournaments with club teams. Yes, the AYSO elite teams can compete with the club teams - but then the core teams suffer. not so much from the cost that is spread to all the players, but more the absence of the kids that take it seriously enough to even think about playing in high school. From there it is a self-fulfilling death spiral with kids that don't think the game is fun, and parents that are entirely disengaged. They don't pay coaches or referees so those that do volunteer take on the brunt of the effort with little to no thanks from those that don't.
Then there's the club teams. It's pay-for-play and the good players are always getting recruited to play for one team over another. That sets up an unnecessary, usually pretty toxic competition between clubs before the teams even take the field. This does not even mention the other club teams that are based along, shall we say, ethnic lines.
This all adds up to a tremendous demand for field space, especially lit fields. This demand is taking place in towns that have long established baseball fields that are not to be touched and schools with their own agenda. This did not happen when I was growing up - kids want to play, there's a field, go at it. Not anymore - now anyone, be that a city, school or private, gets paid if a team steps on their field, either to play or practice.
This all leads to big money being spent before kids are even old enough to try out for a high school team. Maybe not so in smaller areas, but in the city I live in you can forget about playing in HS if you are not on one of the better club teams. And the result? Kids know a dead-end when the see it. only the most ardent quit before they are even old enough to play 11 a side on a full field.
LSS - my kids play lacrosse. It's expensive because club is our only option and we have to travel for both practice and games. Remember what I said about fields? Lacrosse gets the scraps that soccer leaves behind. We like to say the water polo teams get higher priority than lacrosse. My kids are starters on their high school teams and have/do/will play on a college team. I tell every parent that will listen; if you want your kid to have opportunity, it's on the lacrosse field, not the soccer field.
Does that answer your question?