It would need to be a bigger role than that somewhere bigger at a club like Man Utd. Somewhere he would have his own little role as part of a bigger setup. Being manager of a club is just all wrong for him. I know what Jimmy is getting at but I don't think that means he should be given up on as a lost cause. Someone, somewhere, surely could offer him a role of importance that involves football as many days a week as possible.
To be honest, I think he'd be regarded as too much of a liability for a big club like Man U, and he won't be fit for any kind of job until he's proved he can stay off the booze for a fair stretch of time.
It's his responsibility to try to help himself with support, not for someone to nanny him 7 days a week.