The simple answer is that being drunk is fun, because it releases their inhibitions. But only for a while, then it becomes horrible. Most people, eventually, start to realise that it is possible still to have fun without feeling horrible afterwards.