This 100%.
They gotta love playing. And parents gotta love - or at least tolerate - the travel and being on the sidelines. Consider out of state showcases/tourneys as vacations or family trips. Build memories in the journey. And enjoy and learn from it. Anything else (college or beyond) is a bonus.
It's certainly a terrible financial investment. But if you just consider it a family activity together and not an "investment" then it's fun and something to do. If they don't play soccer (or any other sport), it's not like the kids will sit at home and not do anything else at all. They'll do something else - music, debate team, dance, arts, gaming, spelling bee, whatever - so it's not a "complete waste" if it doesn't lead to a "return on investment".