I agree with some of your conclusions here, but the only way I can think to solve it is through machine learning and higher levels of abstraction.
We’re abstracting away the manual intermediate steps of the bi sphere (this is the birth of connection protocols, of transformation protocols like dbt and metriql).
What an internet of BI would need to solve for is agency - or in other words the ability for you as the user to feed commands and create a desired state.
The dawn of this type of tech is starting to show itself (see github copilot
https://copilot.github.com/).
The rough process of:
• provide authorization
• discover available endpoints
• intelligent schema inference
• intelligent rapid modeling
• natural language translation to query on most viable model
I do see this viable in our lifetime, but there’s a ton of dependencies and consensus needed to achieve this. You will likely see products that achieve this in silos before wider market reach. But for sure this is an amazing vision to have!