The singer was magnetic in a performance at New York's Frick Collection of a Jacobean relic with a cringeworthy storyline