Well, there's Ann Miller singing Cole Porter's "Too Damn Hot" in Kiss Me Kate. One of the sexiest G-rated scenes I've ever seen in a movie. Here's the 2002 UK cast video
Christine Lavin had a song about heat and air conditioners in New York City, but I can't find it.
-Joe-