McCartney was the first woman to shoot the cover of Rolling Stone, and she herself appeared on the cover with husband Paul twice