as far as i'm aware, it forces a unit to pass a magic resistance check each turn, or skip their turn. maybe that's wrong
i once had a sorceror use fear, and most of the time when i tried to attack him, it just said afraid on my unit, and they automatically missed. i lost that battle
so i think it's related to attacking the source of said fear