All credit to this goes to bs000 From the True Achievement site if you wish to give this a positive vote please go there and upvote his. I only bring this over to the True Trophies site as I wish for this community to have guides that are easy access. I have not made any edits as his guide was perfect in my opinon. Any use of ths word I outside this paragraph refers to bs000.
This is part of the main quest in Chapter 5. It is story related, however not every cannon has to be destroyed in order to progress. There are 4 cannons in all. If you happen to miss them, you can backtrack and collect the rest.