Mine only honks if it's fully locked - i.e. all the doors are closed.

If you leave a door open and lock it it's silent, I guess to tell you it failed.

So it's not a useless feature, although it doesn't have to be an annoying honk, a quiet chime would work as well.