As we don't have a death option in this new pack I downloaded a death by terrified mod and put 4 roomies in a new house to see what would happen.. Lot traits (mod) possessed grounds spooky and creepy crawly.
While the roomies were eating dinner the first ghost showed up :)
https://i.imgur.com/btYIsfm.png
Hudson (the darker haired male sim) is the only sim out of 4 is the one that is scared..
https://i.imgur.com/HIzb9Fj.png
Hudson becomes so terrified the grim reaper turns up at the house-)
https://i.imgur.com/QPOFy7O.png
The other 3 sims don't try help him and sims do not start screaming to be calmed down? so the next thing is Hudson has died
https://i.imgur.com/t5tdLJg.png
everyone is crying even Grim and the ghost that scared him to death in the first place-) but the overriding emotion for everyone else is the sad moodlet
https://i.imgur.com/rSrCjWV.png
finally he shows back up as a ghost :)
https://i.imgur.com/a0iPeMN.png
Admittedly I used a mod so terrified sims could die but this as a first attempt is not really what I expected. I thought they would all be scared because as yet prior to gamepack release none of them had the brave trait so from this test 3 out of 4 sims never took any notice or react to what was going on until one sims died..