Multiplex is pretty much spot on, there's just a few things I'll add.
As well as the masts shape adding "area" it also helps the airflow to stay stuck to the sail. This minimizes the "separation" bubble.
The separation bubble is the area after the mast where the airflow hasn't re-attached to the sail. It has two negative effects:
1) It causes turbulence as some air is drawn back towards the mast to fill the bubble.
2) The drive a sail creates is roughly at right angles to the cloth (see fig 5&6 on this diagram)
So if the luff isn't creating drive because of the separation bubble a lot of forwards drive is lost, this is especially important upwind.
Obviously with a skinny mast the separation bubble isn't as big, so the benefits of wing masts are reduced.
As to why they are more common on cats, I think the weight is a big factor,
As far as I know, until recently most wing sections had to be made with metal, which made the masts pretty heavy. Cats are more forgiving to having a heavy mast swinging around above the boat, they have to heel quite a bit before the mast goes over the leeward hull and starts adding to the heeling force.
This is made worse by the fact that, because of their shape, wing masts flex more sideways than they do forwards, which is the opposite to what you want from a mast. So they need to be beefed up even more.
So while cats were evolving with wing masts, dinghy sailors were using bigger rigs and using the stays and spreaders to bend the mast and tune the rig (that's not to say most cat masts don't need tuning).
So by the time it became feasible to make wing masts out of carbon, dinghy sailors wanted masts with specific bend characteristics that wing masts couldn't provide (both by being the wrong shape, and the logistics of having shrouds and tight rigging on a rotating mast was impractical)
The big exception to the rule is the NS14, but I think that succeed because the hull was also very efficient, it was sailed by some good sailors and they were restricted to a relatively small sail area, so it was important to get the most out of that area.
A good example is the Cirrus Icon that is currently being developed, it's based on the NS14, but has more sail area, and after testing they've decided not to keep the wing mast and to use a skinny mast instead.
Note: I havn't sailed any boats with wing masts (other than a Hobie 15, and that hardly counts as that rig is awefull). All this is based off what I've read in books (mainly Frank Bethwaite's High/Higher Performance Sailing) and on the web, so I've probably missed something.