YMMV.
I've trained my kids over and over and over on safety. Basically the Eddie Eagle course with no eagle.
During the last monthly 'Daddy takes out the guns and you get to look at them' we found that my oldest was able to rack the slide on not one, but two of the handguns that I keep loaded (but not chambered).
I have no concerns that my daughter will be playing with my guns. There is no mystery, nothing other than a constant drilling in about safety.
My Glock sits on the top of my nightstand. None of the children have ever touched it. It sits in the same spot, and has for so long that there is a dust free spot where the gun sits.
I learned how to pick locks breaking into my dad's gun cabinet. There isn't a lock that can't be defeated if your kids really want to. Same thing with a criminal. My kids worst punishment for mishandling, or handling without permission would be a swift corporal punishment followed by an uninvite to the next time out to the range.
They know they can't handle the guns without my permission just like they aren't allowed to use my tools without supervision. Same exact concept. I'm actually much more scared of injuries if the garage with power tools than I am in the rest of the house with firearms.
When my oldest locked the slide back on two handguns, my wife and I had a little discussion that night about whether we wanted to move to putting them in the safes. We jointly decided that our eldest has the discretion and sense not to handle them without permission and that we didn't need it.
My kids get the same rules of safety with using 'tools' as they do firearms, because to me, they are just tools.
However, if I had revolvers in the house, I would take additional steps to secure them. I'll also add that my kids are never unattended at home, and they have strict instruction and repeated lessons on what to do if they are somewhere else and become unattended around firearms.
I trust my kids. They have earned it.
While on the note of securing handguns, are all of your knives secure? I have dozens of knives all over, and most of them are sharp enough to shave with. Those are left where they are for the same reason that the guns are. They are where I want them in case I need them. What about kitchen knives? And they get the same kinds of lessons with knives as they do with other 'tools', to include firearms and power tools, etc. I've been giving them these types of lessons since they were old enough to talk.
Like I said, YMMV. Talk to your wife, figure out what works for you. My children are also well behaved, and emotionally balanced. If you had some concerns with your child's behavior and ability or desire to follow instruction, prudence would dictate that you take additional precautions.