The singer came out of retirement to sing “Cracklin’ Rosie,” “I Am … I Said,” “Sweet Caroline” and several other songs for a benefit show