Yes, it very common (at least in the US). It's a colloquial, humorous expression meaning to go crazy or react with strong emotion (either positive or negative). Most likely, it was originally a metaphor referring to a pot on the stovetop that got too hot, causing steam to flip the lid off.

The phrase means to react dramatically or angrily to something or a certain event that has occurred.