One of her most beloved musical moments was her riveting performance in Scorsese’s The Last Waltz, when she forged a friendship with The Band’s singer-drummer