Only 2 shots. 3 shots are only available for the Knight and the Sylvan Elf.
And now, Gnomes also have it. I've noticed that the more you upgrade the "War Machines" skill for Gnomes, the more aggressively neutral units attack the ballista, trying to destroy it. I think it's simply because it becomes weaker than a stack of regular warriors.