Against a glittering backdrop and to the beat of a powerful soundtrack, an art museum exhibition gives the Dollys, Whitneys and Marías their due.