In the case of DGA/SGA, it means that you get your healthcare from the union, not your employer. So as long as you're a union member in good standing (and the dues are substantial, just to be clear), you have healthcare coverage through them.
My main gripe with Unions are the huge costs and the major lack of benefits people receive. I'd also prefer to join a Union that isn't hugely centralized and falls to the ills of bureaucracy.