The spell itself doesn't become a fear effect, though the Shaken condition still is.
If you cast a Fearsome Bestow Curse on someone, they are unable to cast spells with emotion components for three/four rounds (unless Shaken is removed early), not for the entire life of the curse.