The story
Compare piss down, piss it down, and French pleuvoir comme vache qui pisse (“rain like a pissing cow”).
Etymology from Wiktionary, CC BY-SA 4.0.
like a cow pissing on a flat rock
Today it means: Heavily; copiously (and often loudly). Full definition →