Memphis-born, Stax-trained musician and singer also contributed to George Harrison's All Things Must Pass and Eric Clapton's 1970 self-titled album