As a filmmaker and not strictly a CG artist, I work with multiple formats all the time, including ProRes as well as various brands of raw.
IMHO, image sequences are one of the best ideas that came into the world of CG and I don’t see a huge advantage to rendering straight into a format such as ProRes.
Let me elaborate – aside from the obvious reason that DCC’s have a tendency to crash during rendering, as well as the fact that a lot can happen during a render session which can go from several hours to several days (power outages, cat stepping on the power strip switch, etc.); there is a great deal of information that it’s often necessary to be carried out of the DCC and which most video formats don’t support such as separate passes for alpha, depth, specular, Cryptomatte, etc. There is also the possibility of having a few frames glitch for some reason, which in a ProRes scenario would mean needing to re-render the entire sequence, or at the very least re-render the problematic sections and then having to edit those in over the glitchy frames which can get rather complicated.
There is one last idea that I would bring forth as to why I think being forced to go an extra step before finishing the project is a good thing – some of the best looking CG renders you have ever seen online have been post-processed (in Photoshop for stills, and a compositing app and NLE for video) and this is a good thing IMHO. It forces one to look at the images within a different context and within a different mindset. When we’re working in a DCC, we’re hyper focused on the small detail such as lights, shadows, textures, scene placement, camera angle and focal length, etc. Once that footage is brought out into a NLE or compositing app, it becomes more about the overall image and the impact that it provides. Our brains switch from micro to macro, we stop focusing on the small little tweaks and start looking at the whole picture. This allows for a better flow of artistic ideas that can guide us toward the final image. We’re looking at overall framing, hue, saturation and luminance, etc.
Anyhoo…this is very OT, but I wanted to chime in as to why the ability to render in ProRes or other container formats might not be such a big necessity.
P.S.
The thought did occur to me that some people like to do their compositing, final grading and even editing in Blender, and in such a scenario I can see why they would want to spit out a final final render in a publishable format such as ProRes. I personally would highly advise to still consider using another app for your finishing pass such as the free version of Resolve. It will help rewire the brain toward this other portion of the creative process that I described above.