There are some cars that use the car (not alarm) horn when locking so maybe their central locking system is connected to it, although it never looked like a factory option, rather an OEM alarm or something similar.
I haven't noticed cars anywhere else doing this, but I'm not that well traveled.
See: http://www.legislation.gov.uk/uksi/1986/1078/regulation/99/m... , https://www.legislation.gov.uk/ukpga/1972/20/section/196/ena...
https://www.racfoundation.org/motoring-faqs/mobility#a6 suggests it's about 35% of vehicles in large settlements.
I don't find it too bothersome, but maybe I'm just used to it. In some other videos people are suggesting that it can be disabled on most vehicles by holding the lock and unlock buttons simultaneously for 2 seconds.
Every GM vehicle I have ever owned honks (via the car's horns) on the 2nd lock.
(a) there is not a seperate alarm horn (b) removing the horn, also disables the 2nd lock honk.