I don't think he's hit bottom yet. He's very close. But, he's questioning some of the choices he's made and that's good. The holidays drove the guilt home more so than any other day thus far.
Continue doing what you've been doing. He knows that you love him and now he is very much aware that you have forgiven him. Keep the candle burning in the window, for he will need that light to guide him home one day.
Sit quietly, the answers will reveal themselves when you least expect them to. The past is gone, the present is a gift and you need to focus on today, allow the future to reveal itself when it is ready.