It only works when the 'launch harpoon' message appears. Press left on the right analogue stick to trigger it.