Well, yes, no one's ever gone broke underestimating the intelligence of the American people.
A large segment of the American public generally supports unions but also believes people should have the choice not to join them. This makes them stupid how? Right to work laws don't ban unions. If people were truly convinced that joining a union was in their best interest, right to work laws would be irrelevant.
Plenty of industries -- like domestic work, most retailing and food service-- are non-union. Anyone who thoroughly loathes unions is welcome to work where unions are rare. Usually the pay is atrocious, but that is another story.