He was a bit of a disappointment, to put it mildly.
During the Gay marriage debate he expressed real misgivings about appending a thousand years of social norms and then voted to do just that. I heard accounts that his lesbian niece really pressured him. So all this social ruin may have been brought because Kennedy was afraid of not be invited to Thanksgiving.