You should try flying inside the cannon before you detonate the C4. That would be more likely to blast you into the air, I think.