I think that long term, AI tools will be like the calculator. If you are a skilled and talented DnD creator then the tools will enhance your output and make you even more creative/productive.
The downside is there will be a lot more mediocre stuff released into the wild. AI will never be super...