Use exception translator in python bindings

[mwestphal]

Is your feature request related to a problem? Please describe. The python bindings rely on handling and forwarding exception manually, use exception translator instead: https://pybind11.readthedocs.io/en/stable/advanced/exceptions.html#registering-custom-translators