I'm terrible at this game's actual objective of landing on other planets but I think I'm ok at making cannons at least

It does indeed work, and with better stability modules the projectiles manage to fly in a relatively straight line until they run out fuel. If using a mod that adds in cranes, you could effectively fire it forever if you carefully lower projectiles into the loading tray.