In my opinion, creatures shouldn't become completely different after an upgrade. A ballista turning into a flamethrower is a bit much. Although, who knows what those dwarves are up to.
It looks clunky.
And can't you make it move without animation? - I don't know exactly how it works, but why does it need animation to move? - at most, the non-rotating wheels will be noticeable.
Regarding movement: if you add movement animation, you'll have to remove one or even all of the dwarves. However, if you can synchronize one with the ballista, you can add a second one. I have a couple of crazy ideas:D although, originally, I planned to give the mage a teleport spell in case the ballista gets suddenly blocked. In principle, this will greatly increase the importance of the mage, and the spell can also be used in attack.
The ballista on the fourth tier looks pathetic. It should be a higher tier. On the sixth, by the way, there are no archers at all, so it will look good there.