It is like having all the doors to your house locked but not shut. Locked or unlocked... doesn't matter, everyone can walk right in.

Turning on sheet protection is like shutting all the doors at the same time, and once the doors are shut, people can only walk in through doors that are unlocked.