A lot of background on the practicalities from one of the Sora private beta-testing teams: https://www.fxguide.com/fxfeatured/actually-using-sora/

„Air Head still needed a large amount of editorial and human direction to produce this engaging and funny story film.“ This included using Adobe After Effects.

N.B.: The article states that Sora is a “diffusion model.” That’s not entirely accurate: rather, it’s a diffusion-transformer hybrid, according to the OpenAI tech report on Sora.