Under teenage years, your kid is much more likely to die by assault by firearm than by suicide/accident by firearm [1]. It is not easier to fight off an assault while you are unarmed.
Under age 5, by your rationale you probably also never went to a house or anywhere else with a swimming pool, which at that age is as likely to kill your child as a gun. Operating based on this, a good case could be made a household without teenagers may be safer with a gun (assuming you are the owner and you don't assault children, and you either store the firearm on your person or secured in a safe) for protection against assault, while those with teenagers have to counter the risk of suicide by either not owning a gun or putting it in a secure safe. But then again, teenagers are still yet more likely to die by (firearm) assault than (firearm) suicide, so perhaps even they are better off if their guardian can defend them against armed assailants.
As a final note, assuming you do actually take your children places: your hosts probably lied. Not all of them did, but a few probably did, especially if you left the Bay area. Even the ones that are 'honest.' They knew that you would be uncomfortable about firearms in the house, and they themselves would be uncomfortable if their friend found out, so they simply locked them up somewhere in their house where they would never be found or could be accessed and then told you there weren't any there. I don't have the study off hand, but a well researched study I came across showed only ~30% of people truthfully inform guests with children about guns in their house.
[0] https://www.nejm.org/doi/suppl/10.1056/NEJMc2201761/suppl_fi...
[1]https://injuryfacts.nsc.org/home-and-community/safety-topics...
https://www.nejm.org/doi/full/10.1056/NEJMc2201761
Fortunately, I'm able to live my life without being forced to own a gun, and am allowed to keep my children out of homes that have guns in them.
But Im not allowed to build a life that isn't centered around transporting my child by car, or subjecting them to car violence while on bike or foot. There's no escaping it, especially in places like the Bay Area that have completely fetishized transporting kids by car. There are better lives possible, and my partner and I are just trying to figure out the two-body problem of moving to a better part of the world without one of us sacrificing a career.