Hi, i dont suggest counciling but each to their own
I care for my wife 24/7 since 1996. There is no easy answer and as you have already said your husband is now only just realising how sick you actually are.
The best advice i can give to your husband is he has to cross that thresshold of of accepting the fact that when you say "your too tired" to do x,y,z he just has to accept it and deal with it at every turn your MS takes.
There is no other way. It's an attitude adjustment unlike no other that has ever been experienced before. It is a total life changing event.
And thats a total life changing event for both of you not just him.
My wife used to faint a lot too when she was going down hill fast. she would be in the shower and then "clunk"! hit the floor passed out.
Have you suggessted to him to read some of the posts on MS websites about what people are going through to get a better understanding of it?
IF i could talk to your husband direct as i did to another husband recenlty i would simply say , To live life the best you can now on a daily bases and treasure the time you have now with each other.
And whatever your wife says or feels you need to accept it and acknowledge it even if you don't understand it or it frustrates you. Then try and focus on any positives you can and move forward. Life is too short to be mad and angry all the time.
Eat healthy to help cope with the days you do get sick on and live each day the best you can.