When I left Texas CPS was a broke-ass mess and had been for decades, I expect it’s not the same yet I doubt it is much improved.
Firearms left out might only trigger a visit to a family that is also POC, but only really because they’re POC, not the firearm. The good aspects of CPS & CPS personnel I would expect to have to focus on the most severe and acute situations while letting the lion’s share slide. That how it was when I left.