The output looks good to people who are poorly versed in the segment for which AI is being asked to perform, but often inefficient or fails in ways that an expert in the field would never miss.
---ignore this part, I'm just rambling from here on Depending on the context, you'll almost certainly get something that looks correct on first glance, especially if you're not an expert. If you're an expert, you wouldn't need to ask for such a task and, if you did to save time, you'd probably end up adjusting, correcting, or fixing several things to produce a production-ready output. I use it regularly for code because the last language I had any training in proper syntax was Fortran 77. And eventually the simple tasks I ask it to code for me work. I've asked it to do some excel calculations (I'm not an excel expert, I do a lot of mathematic manipulation in custom sheets) and some of them work, but most are either wildly convoluted or relay on obscure calls/functions rather than simply using standard logic and mathematic operations which are easy to edit and change. I've also asked it to do some graphical illustration (because I'm not a graphic artist) and it has produced nice looking illustrations with zero basis in reality - i.e. "draw me an outline of Scotland in the style you'd see on a tourist map and label, with a star, these four cities". It produced what I would expect an average American would estimate the outline of Scotland looked like and was equally as accurate with the location of the four cities (i.e. utterly incorrect).
One of my first big jobs at NASA was as a lead engineer on a multi-experiment platform to fly on the space shuttle. I checked all the work and compiled all the data and trotted my 27 year old self down to Johnson to present my case to the Safety Board. When I stood up to present, the head of the panel asked if I knew why I was there. I confidently told him that I was there to walk them through my evaluation of each of the payload components and show that the payload was safe to fly. He smiled. He then said "You're here because if something goes wrong on this mission, there had to be one ass to kick. Proceed."
Everyone needs an ass to kick, and AI doesn't offer that function.