Sorry you are going through this op. It sounds like a lot of unrelenting stress. Only you can make the ultimate decision to stay or go, but a couple of thoughts spring to mind ...
I think a lot of people have become "bloody miserable" during the pandemic. It's been quite hard for everyone in terms of the stress and uncertainty, many couples have seen more of another but they've seen one another at their worst. Don't underestimate the impact of that.
And fwiw, I do think you are being a little harsh on your DH about his chest pain and the evening out. He obviously felt on trial. There was obviously a lot of expectations placed on the evening from your side and so it was quite high stakes for you both. Why would you think that a night out with family and friends would help you both reconnect? Have you planned any dinners out just the two of you?
Sorry if I have missed the back story, but how long has he been depressed for and was it a particular event that triggered it? What are the reasons behind it? To me he sounds classically depressed (the sleeping in the afternoon, the anxiety etc) and it's very hard to make the effort he has when suffering with depression, so he deserves a lot of credit for that. It's awful for you having to live with this depression, but try to bear in mind no one wants to be depressed, they don't choose it. (And yes it is their responsibility to try and recover from it too.) It is an illness like any other. Has the depression made you lose respect for him?
Has he had his heart checked out properly? No chest pain should be ignored.
Why don't you tell him that you still find him physically attractive? That would give him a boost I imagine.
If he's on ADs, he may be very anxious about sex, as the medicine can cause side effects in that area.
You say contrary things about your sex life. That you don't miss it. But you also want him to find you attractive.
You mention your family quite a bit. I could be wrong but I get the impression that they play a large part in your life and there's nothing wrong in that. But have you prioritised them over him? Does he feel pushed out?
I think you would both benefit from marital counselling because the communication between you isn't good. No one's fault; it could just do with improvement.
Lastly. You deserve lots of credit for your strength and for keeping things "normal" for your little girl.