The first time I came across the usage of this phrase was in the movie Hellraiser, and I had no idea this was a common saying. Clearly though, there must be a double meaning there in the movie that I couldn’t fully grasp without knowing the more colloquial meaning.
The description on Wikipedia is unfortunately not enough for me, I would like to see examples. And it’s very hard to find those because Google gives me mostly links to religious websites.
I’d say that that was normally used as someone witnesses or realises the extent of damage or incompetence or misbehaviour or similar.
So, if you came home to find that the dog had ripped the stuffing out of your sofa and spread it everywhere and had broken three plant pots and a window and knocked the bookcase over.
Or, your brother tells you that he had borrowed your car and had a crash and had written off someone else’s car and he wasn’t insured and had been arrested and had been drinking.
Oddly specific