I think the idea is that at the end the sling starts to unwind too, increasing the effective arm-length (that non-linearity is one of the reasons trebuchets are so efficient to begin with). As a result it's possible that decreasing the spool to near zero is like putting the gears of your car too high. Reducing the spool size ensures there's enough torque left to put more power into the final swing.
I think the idea is that at the end the sling starts to unwind too, increasing the effective arm-length (that non-linearity is one of the reasons trebuchets are so efficient to begin with). As a result it's possible that decreasing the spool to near zero is like putting the gears of your car too high. Reducing the spool size ensures there's enough torque left to put more power into the final swing.