I'd be really angry. Not so much that he didn't want to have the snip, but that he won't verbalise why. Of course he has *some* reason, and you deserve to know why. This isn't just his fertility he's dealing with, it's yours too. I find a really common worry is that it's somehow going to emasculate them. While in reality it's baseless, men can have illogical feelings too. But again, you have a right to know that reason.
If I were you I'd try to get to the bottom of the why. If he's still refusing point blank to get it done but also refusing any more children then I would be telling him it's condoms and if there's a whoopsie it's on him. Not to be childish with him, but bc that's the reality. You don't want to be on the pill long term with good reason. You aren't 100% about no kids and frankly from what I've read tubals have lots of complications. IUD's fall out. He won't do anything, so it's condoms.