“Here come the police!”
“Oh no! We’re in hot water now!”

“I’ll be in hot water with my boss if I don’t finish this report today.”

“Hot water” means “trouble”. If you are in boiling hot water, you are in trouble, aren’t you? Imagine you have been captured by cannibals, or you are a lobster, and you are going to be boiled alive. That’s serious trouble!