I promote vasectomy highly for those who actually have sex, because it does reduce the risk of getting someone pregnant but it’s still not a zero risk thing.
https://www.spermcheck.com/vasectomy-blog/vasectomy-failure/
That’s a huge part of the reason I’m so committed to celibacy. It’s the only way to not risk anything. Not just avoiding the risk of pregnancy but also sexually transmitted diseases.