As it stands right now, sims are able to sleep while in the scared emotion, which makes no sense to me. When I'm scared, I cannot sleep. This is a very common thing. You should need to calm yo...
I agree with others that it would have made sense if you couldn't get them to sleep while terrified, but not scared. I've gone to bed when scared a few times.