McCartney remembered the “supremely talented” producer and musician, and the “private moments we were lucky enough to have with the great man”