to drunk to have sex

My husband and I have been trying to have a baby for over a year and I've had to deal with a lot of health issues during. Recently we got the okay to use clomid and a trigger shot. My doctor was very specific that the day after finishing the clomid we needed to have sex and then every other day. My husband had the day off yesterday and while he did a lot around the house he also drank... a lot. He feel asleep on the couch before dinner and then when we made it to bed couldn't stay hard or finish. I'm so angry at him. Part of me feels like he did it on purpose and the other part of me feels like he's just an idiot. I know we still have a chance to get pregnant but I feel like he's really not on board. Opinions? Suggestions? Am I just being too sensitive? 😩