Welcome from Alabama!
I don't have kids but can appreciate your dilemma. I'll bet if you search this forum you can probably get some good thought starters on what may be an acceptable solution for you.
My dad had guns and we were taught about them from a very early age and learned to appreciate them for what they are. This may be a place to start, even without a gun in the house.
Good luck and welcome aboard.