I think it gets better. I"m sober six months now and tho it did take some effort and sacrifice, the results are worth it.
As to how to 'have fun' without drinking... I'm not much of a 'social butterfly' so don't miss much as I never drank out with people but home alone instead. I do, however, like feeling good in the morning. I do like eliminating all the risks that drinking brings. I do like being awake and aware instead of drunk and/or sick. I do like not spending money on wine every day. I do like being able to cope with life without getting numb and then sick.
You will have to learn new coping skills and learn how to have fun without drinking. It means making changes, but they're good changes and worth the effort.
Welcome to SR!