Yeah text-prompting only won't replace production work, but it can surely accelerate and boost pre-prod work, maybe doing prelim shots for a storyboard, creative ideas for the costume dept... lots of cool things.

I think for prod work it needs what the auto1111 plugins have given SD - ControlNet etc, where you have a lot more control over the generation and the text prompt is just a small part of it.