I'm glad you did the right thing, and that he will live to have another chance.
Please don't lost sight of the fact that YOU just went through trauma also, and maybe find some support while you think of what the next move for you should be.
I know my son OD'd a few times as well, and there came a point where I could no longer live in fear of "the next time".
"We" are not the only solution for them, we are not even a good one. There are many places that will help them if they are willing. If they are not willing, all the worry in the world cannot save them.
I will keep you both in my prayers.