Spearmintio every sympathy.
I think firstly, keep in mind that the Health Visitor is not living your life and has no fecking idea of what you are already doing. I've noticed with quite a lot of advisors that they are willing to heap extra work and burdens on your shoulders saying 'this will help' without considering you. I didn't realise how heavy it can be until I got help for our son. That help does suggest doing more for son, but they also ask -me- how I am and how much i -can- do. It makes a difference!
Also, you do what you can. You are not an endless reservoir and you cannot be God and do it all.
So if you can't parent your husband, don't. Do the best you can with what you are already doing. If you have any spare reserves (heh) then frankly - take a long bath or do something you like. Look after yourself.
I stayed with my ex because I really wanted it to work and because I was afraid for the children. His danger-sense is very poor. In the end it was save myself or go under (final straw was that he didn't look or speak to me for a week because some stranger paid me a compliment in passing).
Sadly I had to accept that the children were at risk and in fact he had a local social services intervention for a time, thank heavens. Now they are older and more able to look after themselves. But he cannot be a sensitive and responsive parent, much as he loves them. He really does.
I have had quite a lot to do with the lady who assessed both our sons who also knows ex-H. I raised this problem with her, being able to be sensitive and responsive. She said that as long as one parent can be, then a great deal is achieved and that actually, as long as there is love and that they experience that sensitive interaction is even possible, then it is a gigantic thing for them because they know it's possible for the future.
I think if you have a partner, NT or ND, who is limitted for whatever reason in her / his parenting (plenty of NT parents just shouldn't be parents!) you have to accept that things aren't going to be ideal. It's a bitter pill to cry over.
But then you get up and go on and do the best you can, and remember that love, healthy boundaries and listening to your children achieve a very great deal.