Wasp stings

So is it the female wasps that sting protecting their nests, and the male wasps are off somewhere drinking tiny litle beers?

Worse, the males are out sipping mead (assuming mead actually was made from honey).

Yes, only the female stings. The stinger in wasps and bees is an adaptation of the ovipositor, so only (potentially) egg laying critters have them.