Hold on folks. The risk to a bloke isn't Prostrate Cancer, yep there 'might' be a chance of increased risk, but there are many other life choices that affect prostrate cancer - i.e. not being active.
The operation itself (snip) isn't a big thing if it goes well, and TBH when it doesn't go well it's a few seconds of excruciating pain (been there).
The issue is if the Doctor messes up, or indeed you fall into the 1 in 10 who get Post Vasectomy Pain. Then the NHS doesn't want to know.
Yes I manned up, booked in, wasn't told the risks. I did hold off till Autumn as I wasn't missing my sport/exercise. Anyway, first part of the op was a doddle, then the doctor made a mess, I was awake, but now left in considerable pain 3.5 months later, and don't get any more Urology visits until 6 months post op. Lost 6 out of the last 12 weeks for my sport due to pain/swelling, and now I'm on reduced 'activity'. Popping ibuprofen to the max dose each day to stop things swelling up.
I posted a thread about this, but I've done all the web research, and there is just about nothing the NHS will do for you if you have post operative complications - I had 'real' surgery a couple of years ago, and this has taken much longer to recover.
If all goes well, your DH will be up and running within a few days. If not, and there is a 1 in 10 chance, be prepared for a long battle with the NHS. They so far haven't bothered to take a proper look, just plenty of poking and squeezing, and they are sure there is scar tissue from the internal stitches but won't look into it. I even had to pay for a private ultrasound to check my left ball wasn't dying as they had damaged a blood vessel in the op.
It is still by far the better 'operative' choice for the fella to go through, but when it doesn't go to plan be prepared, the NHS will wash their hands of you, and offer you anti-seisure drugs for the pain - WTF, rather than fix it.
So, if it goes right, it's a good decision. If it doesn't then it's not so good, nor will bedroom antics...