No, it's easy enough to understand the query once the AI has generated it. I have looked up how to do it many times after all.
Yes
If the AI's query pulled what I intended to pull, why should I care to understand the SQL any more than I should understand the Query Plan or the Machine Code?
As with regex, querying is about not getting what you don't want as much as it is about getting what you want. And the former of the two is much more difficult to verify.
There's nothing wrong with using SQL only when you know in advance exactly which records you wish to query.
But if you ever need to query unknown data, then probably you should learn SQL a bit deeper.