I think the big question you need to ask is if your husband's priority is staying an elder. If that is the case, I have seen many elder's wives join what has been coined "the sick wives club". They usually "contract" a nebulous, chronic issue (i.e. Fibromyalgia, chronic fatigue, panic disorders, anxiety, headaches, bad back). Your husband can stay an elder and you'll still get invited to social activities. And you'll not be questioned again. Your husband will probably know you're faking it, but maybe it won't bother him because the brothers will get off his back. I have seen this scenario more times than I can count and it has seemed to me that the elder husband was fully aware of the wife's true health situation. Just sayin!
I am very surprised that your husband agreed to this shepherding visit for you; it violates the headship principle and in all congregations I have been in, elders immediate families are not "shepherded" by the BOE.
In your case, fading will be a challenge that will require a bit of acting on your part.
BTW, I am not dismissing the above conditions as true health problems, but those are good ones to pick because they are chronic, incurable, and not terminal.