I need to do some serious soul-searching...?

The first thing you need to do is to stop drinking, I'm sure that's having a big affect on what you are feeling even when you're not drinking. Go to AA, that would be a good start. You should also go for counseling.