While not a union song, Stan Rogers' "The Idiot" is a good work song; a guy leaves his green Eastern town to work in the Texas oilfields, because despite all he's giving up, a man needs to work rather than go on the dole.

Myself, I think it's a poor choice of title for the song; he uses the term ironically, but you wouldn't know it from just the title.