Sometimes it's the hardest nights which are most beneficial for recovery. You are definitely capable of sobering up, you just need the right motivation. Hopefully you have it now and will be successful going forward. Outpatient treatment may be helpful if you want to step up the intensity of recovery.