Ed, 
I will start out  as always by saying this is entirely MY opinon and I have come to such an opinon from years of  constuction and firing of cannons and mortars. I would view sand  in the same way as I do cat litter  and I know people who use it religously. Both of which have the ability of being packed very tightly, and in a 2 1/4" bore  would take a sizable amount  to seal the breach. I use damp news paper when wadded is No larger than  the size of ball the cannon would fire if loaded with spherical shot, in this case a  wad of newspaper 2 1/4" in diameter It is then seated against the  powder NOT packed. This loading method has worked for me more times than I could count and the report is plenty loud. As far as powder goes 2oz in a 2 1/4" bore would be plenty enough by far. I am against cat litter, sand, clay, mud, matchbox cars, plastic army men, tin cans, rocks. ALL of which I have been told  people shoot in their cannons.
I personally do not use pyrodex, it is my belief pyrodex is a modern made powder it may burn cleaner than black powder but it also burns faster. I have  talked to Reps at Hodgdon and they suggested  cutting the loads in half if using pyrodex in lew of Black powder.
We use Goex and only Goex and in 15yrs of firing loads as large as 1lb in a 3" cannon have had no problems! 
Hunter (dixie) can Replace your cannon ...They cannot replace your life! before loading any kind of projectile be it paper golfballs or  zinc shot instpect your barrel closely and think it out is there anyway this will bind up or get caught in the barrel, How much pressure might it take to push this out (in a Millisecond), will it be easier to  blow this out of the barrel or  for the barrel to burst.
As I said this is  just my opinion..