Every time he goes into the avatar state before then it's because he's lost control of himself and is lashing out emotionally. The avatar state is more or less a vehicle to show him at the peak of stress and emotion.

And the fish one in particular is an "all hope is lost, no avatar has ever failed worse than this" moment combined being straight up possessed by the ocean spirit. We never see him do anything at that level again