I think you BOTH handled it beautifully. It is HARD for someone to admit this type of problem because there is so much shame, guilt, and thoughts of certain stereotypes when you say "addict". But he took a HUGE first step & I think your right to be proud of him, and supportive.
I know there are differing views by some family members on being in control of the medication, however it is something that I would do myself if need be. So I personally think its fine.
My husband main drug was opiate based pain meds. But before he was done with them, he started using xanax also ( a benzo) so when he tried to detox at home, the benzo withdrawal actually forced him to go to the hospital. I have never been through a pure opiate withdrawal so I cant say how bad it will be tonight. There are a lot of people who talk about this on the Substance Abuse forum however. Just take it one step at a time, and know you will both get through it. Tomorrow is a new day with more HOPE for a clean future.