In the thick of battle, there is no time to micromanage the destruction of artillery/siege weapons. Just have to make do with killing/routing the crew and hope they don't rally later on. I've seen enemy crews rally before and that was a pain as I thought the battle was almost over and at the other part of the map, my stationary infantry was getting pelted by an enemy catapult.