QT - call him up and get him home. TELL him how hurt you are, tell him how you needed him to support you by helping in whatever way he can.
If he can't deal with the medical side of it, that's fine, many people can't, but he can help in other ways, like tidying the house, cleaning up and distraction.
You have every right to be fed up with him right now, and he deserves to hear it.
Don't expect him to step up wrt the medical side of things, that looks unlikely, but insist on him pulling his weight and supporting you in every single other way he can. Tell him what you need him to do for you. Draw up a list if need be.
don't let him off the hook. These are extraordinary times for you, and you need extraordinary, unquestioning support.
FWIW I am the Queen of Squeem. I fainted watching a reconstruction of some bod saving someone on a plane, fainted and threw up all over the vet's surgery when asked to hold cat's paw while blood was being taken,
fainted at hospital visiting sister... BUT I STILL WENT TO GO AND SEE HER! Still supported her as best I could.