drivers: sensors: rtio No error reporting from bus controller to application

[FlorianWeber1018]

Is your enhancement proposal related to a problem? Please describe.

If a sensor uses a bus controller with the RTIO there is at the moment no possibility to inform the application if a action of the bus controllers fails. Reporting on success an the moment is implemented with callbacks.
If a sqe to the bus controller fails, the callback won´t be called and the sqe to the sensor never produce a cqe.
A example how a sensor driver uses a bus controller with the rtio could be
https://github.com/zephyrproject-rtos/zephyr/blob/main/drivers/sensor/adi/adxl362/adxl362_stream.c#L234-L246

Describe the solution you'd like

That the RTIO provides any mechanism to get the cqes of sqes in an asynchrounous way.
If we stay on the callback solution for reporting an ok on success at the bus controller, we should at least give the sqes an option to redirect their errors so a different RTIO.

Additional context

Thread: https://discord.com/channels/720317445772017664/1302974460789522523
after Message https://discord.com/channels/720317445772017664/1302974460789522523/1303736670922739767

[github-actions]

Hi @FlorianWeber1018! We appreciate you submitting your first issue for our open-source project. 🌟

Even though I'm a bot, I can assure you that the whole community is genuinely grateful for your time and effort. 🤖💙

[teburd]

@bperseghetti @jgoppert this likely relates to the issue with rtio and cognipilot as well