Hubby got "stage fright"

On doc's orders after my trigger shot we were told to bd two days this week but my husband kind of got stage fright on day 2 and couldn't... I feel so bad because I know he feels guilty but part of me wanted to just scream "I've put myself through the wringer over the past few months, I just need two days of sex out of you." I, of course, would never say that to him because I know he feels bad enough but I was disappointed and let down - we made so much progress with meds this month, I hope it wasn't all for nothing (and I know there's no way of knowing if by skipping a day we missed our chance).
Anyone have tips for how to make it not seem like a chore? I tried lingerie and candles but he just kissed me, told me I was sweet but said not now. I also asked if he could prefer not to be at my doctor's appointments (the magic is in the mystery, right?) but he said even then he would know what's going on and what's expected of him.