I feel stupid for asking this: why does cheating contribute to a vasectomy failing? I don't comprehend the correlation.

The implication is that the vasectomy didn't fail, the uterus-owning partner had sex with another penis-owner, but that one or both of the committed/official couple claimed that the vasectomy failed rather than acknowledge the factual reality of cheating.