O_DIRECT in now way absolves you from needing to call fsync because fsync ALSO sends a signal to the storage device to flush the buffer if it has anything which is important for durability.

What OP is referring to is that some drives ignore that signal for performance reasons and there’s nothing SW can do to solve that part.

io_uring in no way changes the rules here.