These postings seem to always get me irritated, well for me, irritated.
If the OP's friend is suffering from depression or other emotional / mental issues, then OP you need to urge him to get some help. That's what friends do.
However, in the absence of the above, tell your friend to stop drinking and get back to living. Nobody loves the current situation here and around the world. I've always been highly adaptable and for that I'm thankful. Your friend needs to make some modifications to his daily life. Are you lonely and want some female company? Guess what, you need to be a little more creative but that's not a problem w/o a solution. Local theater closed, watch Netflix, etc. etc.
The truth is for me that the grass is just fine here and now and I can wait out the pandemic. Just have to be adaptable.