It's great if you could have found the answer on Stack Overflow and applied it to your code. It's legitimately useful if there are easy (but maybe tedious) ways to accomplish your goal.
It's terrible if you get too vague or what you're doing isn't common. It's worse than terrible if you can't tell or refuse to believe when it's useless.
It's here to stay. It'll likely replace the concept of ORMs, and it'll kill the need for a lot of third party tools.
It's not going to replace many workers. If it were used responsibly, it'd just make people's jobs a bit easier and make software generally more polished and complete. Instead it's going to bury those projects that use it responsibly in AI slop projects.