I agree with idahoflier, I’m not gonna lie, it doesn’t look good. But only Dr. Bruce can say for sure (on this board). And he’s the best on or off this board. Do exactly as he says, if there is any chance. Otherwise if you haven’t yet been denied go for sport pilot.
Some of your story is very familiar to me. I had a crisis (similar to you, the stacking of several bad things too close together) resulting in suicidal thoughts, never any intention of acting on them, but I let myself be talked into getting admitted to a psychiatric unit for two days. In retrospect it was a big mistake. In my heart I knew I wasn’t really a danger to myself or others and there were other options to get help without having “psychiatric inpatient” in my official record to follow me the rest of my life, but at the time I hadn’t figured out the other options and it seemed the only way. But that’s water under the bridge for you now as it was for me.
They put me on several drugs including an antidepressant and fixed me up, however the big difference is I had zero alcohol or substance abuse of any kind. The official diagnose was reactionary depression to circumstances or however they termed it. I reported it to the FAA, they had me jump through some hoops and I got certified. That was decades ago and I’ve not had a recurrence of that depression.
So in your case, the exact diagnosis code(s) will matter. It also matters if it’s a single instance or recurring. But the record of alcohol use is a huge problem. Note I said record. Even if you in reality only had one or two benders, and were never tolerant, it’s now engraved in stone and with you for life, due to the diagnosis code. But you aren’t in denial that you were using alcohol inappropriately to self medicate, and I think you said your wife even found it a problem, so yes, you have a problem with alcohol. So I’m sure Bruce will say it’s the full HIMS treatment at minimum, and that’s even if you can get past the other stuff.
He won’t mislead you, if he thinks there is no hope of certification he will say so, and you can take to the bank that’s the bottom line. He’s the last stop for impossible cases.
For what it’s worth I don’t mind the long story. I appreciate that other people have had similar painful experiences to the one I had. I understand the need to talk about it.