You fire the weapon. The tiny pebble breaks up on impact, creating a little crater in the rock. To you, the medieval siege engineer, this is annoying. The frenchmen taunt you from their parapet, yelling maternal insults and farting in your direction. Your supersonic trebuchet is a failure, tactically speaking.
You can't take their mockery anymore, so you set about fixing your projectile.
The pebble lost much of its energy in flight - drag is a huge issue with any distance to target. You make a projectile in the shape of a rod. This has the effect of decreasing the cross-sectional area of the projectile relative to its mass, minimizing drag losses. There's a limit to the length:width ratio, however- go too skinny and it'll deform under firing forces.
The projectile's length also allows it to burrow deeper into the rock -- when material at the tip breaks off on impact, it's got the rest of the shaft behind it, just as mad.
To pack the most punch into your projectile, you craft it from tungsten (then known as Wolfram). In order to keep it from yawing in flight, you add some rigid vanes at the back. It looks like a small, superheavy arrow.
Now you have the issue wherein it doesn't fit well into your cannon anymore. No mind -- you set it in a cup of sorts that seals the barrel. Wait, where did you get a cannon? This is the year 1217 AD...???
Congratulations: you have constructed an armor-piercing fin-stabilized discarding sabot munition (APFSDS). You load it into your M256A1 120mm smoothbore cannon. You peer through the sights.... now where were those sac à merde?