I think we all agree that Harpoon doesnt have a particular place nor a demand for a place in the list of viable weapons. It gains you speed alright, but it should also be a fairly good tool for chasing. Tested that out yesterday and found that even something with such a small mass as squid could fly away the harpoon until it detached. I think the main problem with harpoon is how inconsistent it is. It's shot spread is affected by ship movement as if you're Indiana Jones running from a collapsing cave and thus is hard to aim, and very unforgiving when you miss thanks to the reload time. While guns with much shorter reloads can be muuuch more effective than harpoon.
Overall, it's both hard to pick up and master, compared to something like Minotaur, which also revolves around controlling airships' movement but does a much better job and is easier to use. The current harpoon definitely needs some kind of buff or else it'll be best at what it does now: An achievement grinding tool.