Depp made a surprise appearance for the heartbreaking tribute, rocking out on his guitar to a medley of songs