From my observations with unchecking the boxes, premade vampires and pets will still be there. Celebrities, however, won't. For example, everybody in Barnacle Bay lost their celebrity status.
Although this may happen because I've also unchecked the box 'Apt celebrities from my current household'(forgot what's it's actually called).
I'm really glad EA created this option, because the vampires and celebrities bugged me, like Schipperke, too. Now I can finally play again without getting annoyed by them.