“We were unlikely partners, and that was part of our magic,” he said during his eulogy for the late Grateful Dead co-founder