I too have had a wavering cavalry unit flee from a ballista with "afraid of artillery" flashing up on its morale. Fortunately they recovered, trashed the arty, and won the battle for me (they and the arty unit were the only men left on the battlefield after a bloody confrontation)