In my experience, catastrophic failure is extremely rare.

An overheating compressor starts burning its oil. That burned oil sludge then clogs everything internally, and eventually the whole system stops being able to work. It will generally get so hot it automatically turns off on overload at that point.