My money is on NONE of the 23 deaths last year from kids/dogs left inside the car having anything to do with the failure of an electric pushbutton door release and the absence of a mechanical override handles as suggested in the original post. My money is on ALL of those happening with cars having conventional door latches and locks with normal mechanical inside release handles. Reason: The percentage of cars on the road that have separate inside electric door releases which are ergonomically separate from mechanical inside door releases is very small, and the percentage of such systems that fail is very small, and the probability of such a failure happening at the same time as someone is trapped inside and which doesn't involve circumstances in which the door couldn't be opened anyhow (collision damage, sinking in water, door physically obstructed from opening, etc) is vanishingly small.
Most of the time ... It happens in a plain ordinary car with plain ordinary mechanical door latches, and the dog or child doesn't know how to work it. So, the original poster wants to have the car call emergency services automatically because I left an inanimate package on the back seat. How is this hypothetical system supposed to distinguish a child/dog from any other object that isn't part of the car? (Hint: There is no way to do this with complete reliability.) What if I want the child/dog to stay in the car at a petrol station?
Or it has plain ordinary rear door child safety locks that mechanically block the back doors from opening from inside. Do you want to ban those? How many deaths from kids being locked inside, versus the number that could foreseeably happen because a child opens the door and jumps out of the car on the motorway? (That's the reason child safety locks were introduced!)
My Chevy Bolt, every once in a while, under circumstances where there might be someone left in the back seats after the driver turns off the car and opens the driver's door, beeps and pops up a warning on the instrument cluster "Check rear seats". I haven't completely sussed out the logic it uses to do this, but every time it has, I can see how prior events could have been interpreted as a possibility of someone being back there who hasn't gotten out before the driver. (There never actually has been a person back there who has been forgotten about.)
Personal responsibility, folks.