Amount of animated sprites for good performance?

It could run.

Lots of details to think about.

The flag at the link below consists of 200 sprites. I set their position directly through code rather than using SDK animation function. Edit: this runs badly on device.

At one time I was doing skidmarks in my game Daily Driver as one sprite per mark and had a hundreds of those. I'd have to check git to see exactly how many. It ran at 30–45 FPS.

So I think it's doable with caveats.