Means it’s raining very heavily. It’s not meant to be taken literally.
“I had to stay indoors because it was raining cats and dogs outside, with heavy rain and strong winds.”