Union membership won't save Kylian Mbappe from being dropped to the bench if he doesn't score enough goals. His endorsement deals or his agent's influence might do it.
I've worked with union shops as clients and I've hit a surprising amount of friction due to things which seemed union related. Things like "that's not my job and we need XYZ to do it" and what seemed like people slacking at their job from the outside. I once needed a desk moved a few feet which required a power strip to be plugged into a different wall outlet, and was told we need to wait for the electricians. Risking the wrath and fallout, I did it myself.
I've also seen this kind of behavior at non-union shops, but it was less explicitly stated and it was relatively easy to do something about it.
I'm sure you're correct about the quality of life at union shops.