This is such a fun idea, actually. Sprites in general (not just 2D 8-bit style) could be really useful for DALL-E to generate. There are a good amount of tilesets and sprite packs for sale online created by pixel artists. But having sprites and tiles generated by DALL-E could really invigorate the indie game community.