Have you tried AI asset generators? They are working extremely good. Just yesterday a friend of mine has shown me the progress they made in their game. It is incredible.
Designers are 100% loosing their job over this.
I'm a professional game developer and excited AI enthusiast.
While I've seen a lot of cool stuff which helps generation for hobby projects or smaller indie games it's nowhere near the quality and consistency needed to come close to the work of a skilled human artist at a larger studio.
Yes, and I studied Game Development in Germany for 3 years in Düsseldorf, got third at the national gameforge newcomer award with my team "Northlight Games" and still have many connections to the people in the business (if this somehow matters). The quality for 2d assets is on very professional level and already replaced jobs in projects I know.
To give you an example join the public discord of https://www.scenario.gg and check out results. Come back and tell me those aren't on a professional level.
I am not saying that designers won't be needed anymore but AI is definitely able to replace jobs and speed up progress in game development.