The ambulance emergency is just one example, there are many more that you aren't considering. As one more example there are many passing situations, such as pretty much any two lane highway, where it's perfectly acceptable to break the speed limit for a brief period. I can think of other exceptions too and this is just after thinking about it for a minute, there are probably thousands of real world situations neither of us could think of ahead of time.
Plus, this is all assuming such a system could be implementing flawlessly. In practice, such a complicated and messy system would have a million bugs. Who keeps the speed limit database of every single road in country up to date? How are all of the precise boundaries of every single speed limit zone going to be defined and recognized by every vehicle?