I created a larger and fairly gunpowder-conservative long-range TNT siege cannon that propels 5 TNT up to 90 meters at the cost of 4 TNT acting as propellant. whyich is about 1.8 TNT cost per shot, requiring 9 TNT for one salvo.
it takes up a fair deal of space though so itd only be useful on larger ships