"If you legitimately open the door by mechanically unlocking the door lock the alarm should not go off. "
It does on most european cars. Disabling the alarm is done with the remote and if you have to go in with a key the only way to silence the alarm is to put a valid (paired) key into the ignition.