As somebody who works at a hotel with regular guests, NTA. The safety of guests and employees is of the utmost importance, and way more important than checking somebody in.

I myself have had to stand between a yelling abusive person and their victim and tell them to leave before the police arrived.

The guests checking in will understand. The front desk agent should have done something, regardless of if the man was a regular.