The playwright Tennessee Williams immortalized this phrase in the title of one of his dramas, even though the cat in his play was a woman, not an actual cat. The meaning of the phrase is obvious enough: an extremely uncomfortable or unpleasant situation. A cat on a hot tin roof would not be able to stand still for more than a second.