OP, quite a lot of posts on here from people whose partners are particularly excellent at helping when they are ill.
I think if you carried out a survey across the UK, there would be a lot more variety and more of sliding scale, as some people (male and female) are better at coping with others' illness than others.
My daughter's dad (my ex) is actually an excellent father and generally did a lot around the house, but was utterly shitty when I was ill - I think it stressed him out for some reason, especially when dd was little - almost like I was doing it deliberately to piss him off.
I got ill at my mom's house recently and actually she reacted quite badly too and it reminded me of him! I think germs stress some people. She is otherwise lovely and an amazing mom.
I had another ex who was just pretty indifferent, and wouldn't have gone out of his way to do all the lovely things some of the posters here say their partners do, though he wasn't an all round evil human being who hated me. Just quite thoughtless at times.
My current partner is actually at his best when I am ill I think. He nursed me through a very serious illness a couple of years ago and was amazing. I think he should retrain as a nurse and have told him so.... He is by no means perfect in other ways, but certainly rises to the occasion when I am poorly.
I would say your partner does sound exceptionally bad around illness, OP. But to draw conclusions about whether or not the relationship is worth pursuing, you do need to look at his behaviour towards you and the kids in totality, if that makes sense?
Either way, I would try to talk to him about this seriously. He certainly needs to attempt to make more of an effort.
Look after yourself - I hope you feel better soon .