It was repealed because people like to drink and be drunk, a little or a lot. When we can vote to get what we want, regardless of the consequences on larger culture, we do. Self restraint in the individual is rare, in the broader society rarer still.
Self restraint in the individual is a learned action.
Self restraint in the broader society is imposed by laws.
Laws that affect the individual for actions that impose direct harm on no one but themselves are not good.