'Tonight he has asked me to do some research on what meds he should ask for'
NO.
Medication is between him and his doctor, and if his doctor isn't sure, he should be referred to a consultant psychiatrist. His health is HIS responsibility, you are his WIFE not his medical support person. If you need to do some of the carer role, maybe you do, but again definitely not researching medication FGS. You are allowed to say 'no I'm not able/willing to do that' just as he should be able to say 'I'm currently too ill to do X'.
Is the business able to pay him sickness pay, has he applied for ESA? How does that work?
Having said that, you could consider going with him to the doctor's appointment, particularly with a view to explaining truthfully how many depressant chemicals (alcohol) he is self-medicating with. Nicotine is a bit more complicated since it does appear to have an antidepressant effect, but unfortunately also kills you; especially when mixed with alcohol. Again, his responsbility, but helpful if the doctor knows how much he is taking before prescribing e.g. medication that won't mix with that.
DH has had severe and enduring mental illness since long before I met him. Things that help: a GP he trusts, a psychiatrist who will see him when he asks, me attending some (not all by a long chalk) appointments; me knowing the contact details for e.g. the crisis team and talking to him about what constitutes a crisis; me having a list of the medication he takes so that I can ensure that medical teams treating him know what he has.