I use a similar tool at my work (airplane.dev) that lets us make dashboards as code using raw SQL or a language of our choice. I love it, and it gets a ton of use from our engineers and customer support folks.
But our CEO, sales, etc. teams that are often consumers of BI tools do not like it, as they do not like SQL, nor putting things in code, nor markdown. So we kept the "traditional" BI tools and ETL shenanigans as well.
It's expensive to have both, but I don't think either fully replaces the other, and I don't regret going down the path we have at all. I think most folks are happy.
We have built a cross between airplane.dev, retool and n8n. It's fully open-source: https://github.com/windmill-labs/windmill
Compared to airplane.dev, our scripts are instantly deployed, run faster, and we are being deployed fully on prem air-gapped, and scale easily to large clusters. Our workflow builder is similar in features to a tool like temporal and can be used to run ETL on nodes with hardware acceleration. Last, our UI builder is more similar to retool so it feels similar to traditional BI tools to build dashboards.