Using cr3 or camera raw files in AfterEffects?

I'm an animator and I just bought a Cannon EOS M200 for myself. I shot a quick stop-motion piece as a test and now I can't access the .cr3 files. I've worked with all sorts of log footage from fancy shoots at work, but I don't think anyone has ever given me raw files from a still camera. I know I can import some of them, but clearly raw files aren't all created equal, and I'm not sure which ones are fine for AfterEffects.

Lightroom does not currently support this camera. I downloaded the software from Cannon, and it will let me open the .cr3 files, but it'll only let me export to tiffs and jpgs. I can see how this software would be helpful if I wanted individual photos, but when I was playing around with the camera this moring, I shot a quick test that's 12 frames long. I can't imagine using the Cannon software for that. The camera also shoots RAW raw files, so I could switch to that setting.

I would rather work on color correction and color balance in AfterEffects, where I can animate the curves and look at the frames in proper order. Is there a best workflow or set of settings so I can make this work well for me? Thanks in advance for any advice you have!