Is vasectomy enough? Considering bisalp.

30s F. Married with 2 kids. I’m done having babies and the idea of an oopsie pregnancy terrifies me. My husband is willing to get a vasectomy but has been dragging his feet. I’ve been really considering making a permanent move on my side after hearing scary stories about pregnancies after vasectomy. I’ve had bad experiences with hormonal birth control so I really don’t want to go that route right now. Has anyone felt safe enough with just a vasectomy? I have an appt with my OB/GYN in a couple months so I want to be sure what I want when I see her. I would love input.