>>
I then ordered a solid shot. It was fired and went somewhere, I don't know where; but it didn't hit the target.
What was the lifetime in rounds of a smooth bore cannon, such as a 12 pounder Napoleon?
How many rounds time on average would a cannon be used until retired?
Or were they used until they burst, possibly injuring or killing the crew?
Bronze cannon did not burst in the catastrophic manner that cast iron cannon did. That was not an issue.
In order to load through the muzzle, 12 pound Napoleon gun / howitzer rounds were smaller in diameter than the bore. As a result the wear on the walls of the bore was not what one might imagine. When you examine the bore of an original Napoleon, there are long shallow scratch marks made by the sabot straps, but no gouges or the like. Bronze is very durable.
Bronze cannon that were cast in 1862 were still in service in 1865. Regardless of their serviceability, 1841 model cannon & howitzers were returned to the depot & then recycled into 12 pounders. Three 6 pounders = two 12 pounders.
The rifled bronze Ames / James cannon were surprisingly durable. In the West, they were still in active service right through the Vicksburg & Tullahoma / Chattanooga Campaigns. During the winter of 1863 - 64 the rifled bronze guns were exchanged for 3" rifles as part of a department wide standardization.
The bronze rifles were either returned to depots to be recycled or relegated to backwater forts & garrisons. A surprising number of them still exist today.
Bronze 'Tsar cannon' - 20' long, 39 tons. Designed in 1586 to fire 890-mm stone projectiles capable of knocking down castle walls. Each round weighed 1,700 lbs.
As far as anyone knows, the 'Tsar' may have only been fired once, which is on one end of the scale. Depending on a host of factors, the rule of thumb for bronzed cannon was firing between 500 & 2,000 rounds before it was recycled. For a perspective, a cannon & caisson only carried ( +/- ) 220 rounds / 4 ammunition chests / gun. With reloads from the artillery reserve, on December 31, 1862 the Chicago Board of Trade Battery's eight Model One Ames bronze rifles fired almost 1,500 14 pound Ames bolts.
Bronze is ductile, which makes it very durable. The simple answer is that bronze cannon fired between 1 & 2,000 (+) rounds depending on a world of factors before replacement… which I agree is no real answer at all.