In story and song at the Café Carlyle in Manhattan, the star makes sense of a career that has included chaste nights with George Michael and drama with her mother.