Famed session musician, who also performed with the Beatles, Tom Jones, Jimmy Page and Eric Clapton, died after being diagnosed with Alzheimer’s