I'll admit I was expecting an explanation of how to extract sprites from retro video game footage using FFmpeg, which I can see totally being possible with a bit of work.

I was thinking the opposite: Using FFmpeg as a sprite engine, to move sprites around, over background layers

Overlaying them at fixed positions is trivially easy, but animating the movement may take some work.