The former Band guitarist discusses meeting Bob Dylan, Eric Clapton, and Martin Scorsese, as well as playing Woodstock and realizing “The Weight” was a hit