When you officially become the Speaker with the Dead, ghosts stop attacking you, however bonelords, bonewalkers and skeletons do not. Lorewise all of them are same ghosts just possesing physical bodies, so there is no reason for them to attack you if regular ghosts do not.