.. How can I load the cannon?

To load the cannon, why don't you pick up some more brimstone?

I mean, gunpowder.

Use the gunpowder from the hold with the tip of the cannon.