I think people are very familiar with "foot gun" which is quite common, and are inferring that since a cannon is a really big gun, a foot cannon is a really big foot gun.

I think "foot gun" (https://en.wiktionary.org/wiki/footgun) is more common.