Sounds like they focused on base game scariness, maybe they will add for misc packs later?
I liked the tense moodlet, I really hope it will not be completely replaced by the scared. Loners surrounded by other sims should still get tense and not scared, at least not unless there is a reason to fear stuff - like if another sim is evil or mean etc, or other negative impacts. I think scared should be more like worrying over your own safety, being tense is quite different...
I'll wait a few days until I patch my game. Anyway, sounds like there will be a few cool new situations with the Scared emotion :)