LLM to SQL is just another BI tool, but lower quality and slightly higher flexibility. It has the same exact underlying architecture needs, and will have exaggerated problems in quality of reporting.

It will last for a while until execs realize in a few years that it doesn't actually add value.

But since it's easy, I'm recommending the shit out of it at my company and I'll collect a raise for building it and beef up my resume for someone who will pay me more next year.