I think it depends.
I have recently been exploring AI generated art, and sometimes (3/10) it makes major mistakes. Sometimes it will accidentally forget to draw someone's arm, or it will forget one of the things I ask. Sometimes it can't handle it when I give like 10 requests, so it only does the first 3-6.
I think for basic assets, yes, it will. But for concept-art, complicated/fine detail pieces, no chance; Humans will forever stand dominant.