There are definitely SIP trunks that allow 911 calling. Mine does, and they also allow you to pay for E911.
What is missing is a way to say “emergency call failed” and pass it to another handler (perhaps even a low-level one built into the cellular part of the phone itself).