Haven't heard that in awhile! However it was quite popular in my youth (and a bit daring for a lady to use!)
Meant someone who dressed "over the top" for any occasion.

Around here, "pissing down rain" means it's a steady drizzle, not a downpour.