Take it slow, give him time and space to figure out what’s going on in his life, and allow this to happen in an organic manner.

You can come clean about the alcohol, apologise for your behaviour, and ask him to consider going out for a cup of coffee.