The former vice president’s eulogy for his longtime friend from across the aisle didn’t leave a dry eye in the house