I'm not an expert or especially well versed, but I feel like I've seen things from midjourney that could pass for semi-professional art, the kind that might be sold at a small time park exhibition on a sunny afternoon.
And with somebody super focused on figuring out the right prompts, maybe tweaking the images slightly, I think it could be workable in a game for sprites, textures, backgrounds.