Greetings

You have described in very detail about the blockchain oracles how they act as a bridge for connection of data from contract to real outside World.

You have explained the drawbacks in very detailed.

in addition, the decentralization benefits of blockchain technology are at risk if a small number of oracles come to dominate the network.

I am agree we must know its drawback too. Yeah definitely decentralized oracles jas alot of advanced features and benefits over the centralized oracles which has certainly issues of limitations.

Decentralized blockchain oracles have the advantage of being resistant to tampering, censorship, and other forms of external interference. There is no single point of failure and greater security because the data is sourced from a network of independent providers.

Hence after reading this i may clear why blockchain oracles and decentralized becoming much popular in the World.
Keep sharing valuable information.

Best wishes