What I've found when it comes to moms/wives that are terrified of the snakes... Have him get a baby, a nice, pretty, beautiful little baby snake, and then don't mess with it yourself. Just watch him interact with it. See how he does, see how the kids do with it, and just get used to it.

Don't force yourself, and don't let him force you. That is the one mistake I see significant others and parents make - don't force it on yourself or on the kids, just let it happen. Natural curiosity will take over at some point, especially if you think the snake looks cool. Just take your time. The snake will easily live 30+ years with good care, you'll have TONS of time to get used to it!

Basically, let him get the prettiest one he can within your budget, let him remain in charge of all the care, and just don't let yourself get worked up over it. Over time, you'll find yourself minding the whole "snake thing" less and less, and eventually you may end up liking it. Maybe even so much that YOU end up the one with all the snakes (that happens more often than you'd think).

Good luck, relax, it'll be great. enjoy!

-Jen