My father is a trades person and when one union treated him badly he left for another one cause he had options. His union has also saved him from a lot of BS that companies he's worked for have tried to pull.
Alternatively when I was a student I worked a part time job where I was forced to be a part of a union with no options. Ever week they took money from my paycheck and the one time I had a grievance they pretty much ignored me. Making sure the girl that showed up hung over and vomiting every 2nd shift was not fired was more important because seniority.
Only some areas like teachers seem to have near-homogeneous membership and unions taking an active role. And this seems mostly to be because 90% have the same employeer - the state (public education). Because of standardized working terms (incl salary), they have to be negotiated centrally.
It should also be noted that the players union represents a tiny portion of the actual employees involved and they actively negotiate money away from other employees.