I'm so sorry to hear how sick you are and how difficult it is for you.
It's okay to be sick and you're not boring because you don't want to go out. Unfortunately our spouses get as frustrated as we do by our diseases and the person they take them out on is us, even though it's not fair.
My husband and I had a similar challenge. One day when I felt strong enough I sat him down and talked to him. I told him how sick I was. I told him how frustrated I was and it was okay for him to be frustrated. I told him I was doing my best. And I told him I needed his support. I explained what that meant - encouraging me when I was doing things, helping me when I wasn't feeling well, letting it be okay when I was sick, picking up the slack when I'm sick. I explained the things he was doing that weren't helpful - my husband is fairly sarcastic so he would make nasty jokes or ridicule me and all that would do was push me down and I explained how that made me feel.
This was a lot to do especially when I didn't feel well. And it was a lot to get a man to listen to. And there are many times when I have to repeat parts of it but our wedding vows said in sickness and in health and I'm sick right now and he's my partner.
As AlwaysRosie said, this is a perfect place to vent. We have some idea of how your feeling. Good luck knocking some sense into your husband's head.
To build on what sillytoes said, cognitive behaviour therapy can do wonders and if you can't get to a therapist a book could do it. There is also a workbook called the Depression Workbook along the same lines. All work on the idea that you're telling yourself negative things and need to "reframe your reframe your cognitions" -change what you're saying to yourself.
I often beat my self up mentally. When I can't do something because I have a headache I tell myself I'm a failure. I have to catch myself and stop telling myself that. I recognize my limits and recognize I'm doing the best I can. I write it down, that helps a lot.