It depends on what AI can do. If AI couldn't create complete sprite sheet or at least sprite set, game artists are still needed to create those.
Yeah, I'm don't know the limit of AI capability in creating art so take my above statement with grain of salt.
That being said, I don't think professional artist would disappear completely. Someone needs to supervise the artwork made by AI and the best person for the job is an artist.
Never forget also that in order for AI to create an art, it consumes electricity so in places with limited electric power, artists would be preferred to save power.