The cannon is represented by a single cannon plus a crew of 3 to 5 dwarves.
You are correct with regards to the single shot however you keep rolling for all units hit in a straight line until you miss one.
Cannons are good for taking out monsters with high Res especially the large cannon can do this across the whole table. In general ranged attacks are more useful for putting pins on the enemy instead of killing.
