OP, I know you're done here, but as a Catholic, I have to say I wouldn't have known off the top of my head that the Catholic Church is staunchly opposed to IVF. Maybe because I never looked into IVF, or maybe I'm just a bad Catholic

, but I really had no idea. So to say you knew he was against IVF cause he was a staunch Catholic is not a given.
Also, I know that urge you have for kids as I had it too. Having kids was extremely important to me and my husband knew that before we were married. Never once was IVF discussed as we were young when we met (and when we got married) so it wasn't on my radar at the time. So I wouldn't have even known he was opposed to the idea (if he were, in fact, I still don't know if he is or not cause we simply never discusse it).
But I do know that knowing how important a baby was to me, he would have done everything in his power to try to make it happen, and supported me along the way. And he is very Catholic himself, went to Catholic school his whole life, is a Eucharistic Minister, went to church every week (in fact we both did throughout college and until we had kids, now we've kinda fallen off the wagon so to speak). But he is extremely supportive of me and would put me above any religious belief he might have rather than know my lifelong dream would never become a reality because he was too rigid.
It was never his dream to have a bunch of kids-my husband would have been satisfied with the 2 we have now, 1 kid, or none at all probably, but was very willing to have the 3rd that is on the way. His dream was to go to medical school and I supported that, sacrificing a lot for myself and our family on the way. My dream is being a mom and he supports that fully as well.
If he were sterile and wouldn't consider a donor sperm route, then we would look into adopting an embryo, and if that couldn't work out, then adopting a baby. I know it's great to adopt an older kid and I would love to do that now, having raised 2 babies, but I know I would have longed for holding a newborn in my arms, so for us the older child route would not have been an option, most likely.
So for me, it would be the fact that my needs and feelings are not important to him that would be so hurtful and demeaning that it would be a dealbreaker. Not that he was sterile, that's entirely different. If he were sterile but willing to search through other options with me, great! But if he said "I feel sorry for you, but you're on your own on this one, honey," then I would be hurt and angry.