Honestly I don't think it would be as bad as one might think. Most people, including criminals, are not homicidal to begin with, so police officers and their families would be relatively bodily safe, and given the effort needed to case a home to verify no one is home in order to break in and vandalize or burglarize, it's unlikely that a police officer's home would be targeted for vandalism or theft either, over and above statistical average.
If anything, if criminals are paying attention to where police officers live, the neighbors of cops might find less problems, as there's a possibility for a quicker response by calling a neighbor (ie, the cop) and more effort into an investigation relative to the importance of the crime, to appease the neighbor. Or it could come to nothing.