I think that applies in the case of young children and their parents, but not otherwise.

What is good fear for adults? Fear can have limited good or neutral effects, like stopping people from killing or stealing because they're afraid it'll be witnessed and they'll get caught, but I wouldn't call it good, fundamentally.