Personally I like the ability to drive myself to the ER or away from an abusive spouse not being dependent on the false-positive rate of some device built by a notoriously shoddy car manufacturer, but to each their own I suppose.
But as for the very specific emergency case while you are drunk, it could be overridden with some visible sign turning on notifying other drivers - but it would need some law background, so eg. a cop can escort you in that case, etc. But tesla’s fake self-driving doesn’t help anyone.