Sure, you could carry it, it's not a bad idea and potentially life-saving. That said, I've been a paramedic for thirteen years. My home first aid kit consists of:

-Several maximum flow sanitary pads

-idk how many big ass rolls of gauze and ACE bandages

-Two tourniquets

-Tylenol, Ibuprofen, Benadryl

I think I also have a SAM splint, but I'm not sure.

That's pretty much it. Current best practice (though it is being reviewed) is still to transport Narcan overdoses to the ED, and if you find someone unresponsive, they could be out for any number or multiple reasons. And realistically, it's unlikely (but not impossible) you'll ever find yourself in a situation to use it. Those two are enough for me to not bother with it, but there's nothing wrong with carrying it.

Kids get into shit. Older kids try shit. So, yeah, it's a good thing to have, even if nobody in your home is prescribed opiates, or uses illegal opiates. All it takes is one bad turn.

And, since it's cheap/free,keeping it around for other people than your family is just being broly, though I would recommend taking a decent first aid class that covers narcan use.

Think of it this way, it might not be your family/kids/friends doing drugs and overdosing, it might be somebody accidentally coming into contact with concentrated drugs where even absorption through the skin can be dangerous.