As a consultant data engineer (ish), I think it has potential. You're right that any company doing data analytics is gonna be prioritizing a single source of truth and a unified platform, but each one will choose a different set of tools, which I'll have to learn, install, and even teach, for each new client. If I can use this to both explore AND implement stuff for clients regardless of their underlying database, that would be a pretty significant win.

Isn’t it useful for when you are getting things into a central DW?

E.g, you don’t need a million tools to connect to the million different application databases when inspecting sources as part of setting up pipelines.