I think you misunderstood the numbers.
A CR3 Maceman has 28% Combat Odds versus a healthy Drill I, CG3 Longbowman.
A CR3 Trebuchet has 74.7% Combat Odds and will do 8 HPs of collateral damage (5.5/6.0) -- increasing the CR3 Maceman's Combat Odds to 57.6%.
A B3 Trebuchet has 18.6% Combat Odds and will do 11 HPs of collateral damage (5.3/6.0) -- increasing the CR3 Maceman's Combat Odds to 59.9%.
----
The increase in combat odds to the Maceman is not +18% ...
it's only +2.3%!!!
Sure ... now that I understand how collateral damage works.
----
I don't have time tonight to do complete tests, but I did rerun the above comparison with Catapults instead of Trebuchets, and the results are the same ... a trivial increase in Maceman odds in exchange for a drastic difference in Catapult survival:
A CR3 Maceman has 28% Combat Odds versus a healthy Drill I, CG3 Longbowman.
A CR3 Catapult has 18.6% Combat Odds and will do 9 HPs of collateral damage (5.5/6.0) -- increasing the CR3 Maceman's Combat Odds to 58.3%.
A B3 Catapult has 1.1% Combat Odds and will do 12 HPs of collateral damage (5.3/6.0) -- increasing the CR3 Maceman's Combat Odds to 60.7%.
So even when using Catapults instead of Trebuchets, the increase in the CR3 Maceman's Combat Odds is still only a trivial +2.4%
at the expense of a -17.5% difference in the Catapult's Combat Odds.
----
And with a Cannon:
A CR3 Maceman has 28% Combat Odds versus a healthy Drill I, CG3 Longbowman.
A CR3 Cannon has 93.1% Combat Odds and will do 14 HPs of collateral damage (5.2/6.0) -- increasing the CR3 Maceman's Combat Odds to 61.9%.
A B3 Cannon has 53.1% Combat Odds and will do 18 HPs of collateral damage (4.9/6.0) -- increasing the CR3 Maceman's Combat Odds to 64.8%.
So even when using a Cannon instead of a Catapult, the increase in the CR3 Maceman's Combat Odds is yet still only a trivial +2.9%
at the expense of a -40% difference in the Catapult's Combat Odds.