drinking to get some sleep isn't necessarily a good strategy. Alcohol consumption stops you going to deep sleep, because your body prioritises getting this toxic substance out of you, and of course if you drink enough you're not actually sleeping, you've just passed out.
Recovering from prolonged alcohol consumption takes time. Your body starts to anticipate your drinking, and starts ramping up the production of hormones and other things in advance ("oh, it's nearly 6pm, here we go,") and then if you don't drink, there's a "WTF am I supposed to do with all this?" moment, when it realises you're metaphorically all dressed up and nowhere to go.
I've posted some stuff about sleep hygiene before, it's one of the pinned posts. I appreciate that not all of it will be possible for you if you're in a residential programme and therefore not in full control of your surroundings, but there's things like coming off your phone, going to bed at a set time, that are all achievable and start giving your body sleep cues to help you get restful sleep.
One thing I will add is that when I stopped, I initially found it very difficult to be around people who were drinking. It's hard to hold a conversation when you're sober and they aren't, which is kind of boring for the sober person. Depending on who I was with, I was on edge about whether they'd forget I wasn't drinking and offer me something.
Could you and your family commit to not drinking while he's staying with you?
There's various pinned posts on here that offer help and advice, it might be worth having a read through those.