So... why wouldn't it work? I'm not that much into the rules but you can fire a magic arrow from a magic bow, can't you? So why not a magic cannon ball from a magic cannon.
But the GM's pretty cruel if he's intending to just kill his players like that.