Most of us have probably made a "Timmy stuck in a well" joke at some point in our lives. It's simply so ingrained in us that dogs will protect us in times of need and Lassie gives us the perfect cultural shorthand to express that.
It isn't just Lassie, though and a quick google can bring up tons of stories about very good dogs saving their humans.