One way to look at it - which is more likely to occur, someone breaking in and you needing the weapon, or your children getting ahold of it when they shouldn't.
I think the answer depends on where you live, what your children are like, where the weapon would be kept, etc.
ANother option...