Is it was raining cats and dogs and more of the same was promised for the next day a hyperbole?

No, it is an idiom because you can't tell what it means by trying to define it literally. Hyperbole is exaggeration - an example would be "It was raining so much we had to row a boat to work."