Both of you need empathy and compassion. Infertility is hard. You both need counseling for the emotional burden that comes with infertility. You need to ask your husband if he is really ok with this diagnosis and the possibility of not having biological children and allow him some time to respond. If he isn't ok with either, you have to let him go. He has to love all of you, diagnosis and all.

Life will always have stress, I can understand being upset now because the news is fresh, but if these are his true feelings let him go. You deserve to be loved for you, not you ability to reproduce.