Having an alternative to cardano-db-sync will help projects in Cardano be more robust as we won't have all projects relying on a single tool.
Additionally, the Oura infrastructure is more modular which will make it easier for projects to write their own plugins based off their own needs whereas writing plugins for cardano-db-sync, although doable, requires understanding a monolithic codebase which is not easy.
Additionally, since Oura is more modular, we expect our db-sync replacement to have better performance which would help wallets like Yoroi load wallet data a lot faster
This protocol is to build a Cardano open source project and should also make it easier for developers to build using open source tooling as well.
The risk of large infrastructure projects like this is that the project ends up containing a bug which affects projects that depend on it. However, the dcSpark team has a lot of experience writing core Cardano tooling so we're fairly confident in our ability to do things properly, and we also intend to integrate the tooling into other projects we contribute to (Flint Wallet, Milkomeda, etc.) so we should be able to detect any issue before others do.