Hi, Welcome to Sober Recovery.
I don't think interventions are a silver bullet - but I do think they can help, if the alcoholic/addict is at a point where they are ready to get sober.
Life does interventions ... job losses, divorces, lost relationships, lost homes. Each of us has our own "bottom" - and what is TERRIBLE for me, may not be more than a blip on the radar to someone else.
That said, perhaps an intervention - with a counselor with training in interventions - could help. But it would involve his wife, his family and friends who love him and some strong, firm boundaries (not threats - real boundaries). If you and the other family members aren't ready to set those, then the intervention might be a waste of time.
I wish you the best.