Dall-E is usually not an alternative to a trained artist, but an alternative to downloading a stock image from the internet, which takes way less energy.
AI generated images have already won numerous awards. They can easily make assets good enough for an indie video game. Even stock images have to come from somewhere