Yes, enabling a custom lock sound will disable the "Lock Confirmation Sound" (one honk for lock and two honks for unlock), and vice versa.
And, if you then disable the one that's enabled, it won't automatically enable the other if it was previously enabled, so you have to do that manually.