In that image it looks like there is volumetric clouds and tail of rocket is some “cylinder” with emission shader that lights those clouds. There can be also some two dimensional density map to control cloud heights in location where rocket was launched.
If you want to animate this, I recommend using particle emitter to tail of rocket where particles have initial velocity same as your rocket engine gas exhaust speed, and set those particles to be as smoke emitters and set temperatures and smoke to be flame that cools down to water steam. Wing vapor and supersonic effects you need to build separately.
Real limitation is the scale and smoke domain size. You should not use 1 unit -> 1 meter. Instead use scale 1 unit -> 1 km, set smoke domain height up to 10 units (10 km) and move it as rocket moves, so you get 10km tail of flame and water steam.
This kind of result should be possible: https://www.youtube.com/watch?v=kNOhNLk0mRQ