I also wondered if/how I would ever have fun sober. It quickly made me realize how much of my "entertainment" was previously focused on alcohol. Seemed like all the "fun" activities I would do involved drinking. Odd thing is that for several months, I didn't really have a desire to do many of them after getting sober. Examples included playing cards, billiards, going to concerts, etc. Even grilling or golfing didn't seem as exciting. After about 4 months though I started to find the fun associated with some of these things like grilling and golf. Still don't care for some of the other prior activities but I think it is because they were just an excuse to drink and gamble.
Good news is that I also found other new interests, more productive times, and healthier activities. In may case it just took some adjustment time but things are so much better now and well worth the effort of working through the process. Wishing you all the best.