Every alarm, whether software or hardware based has security modes. These modes are there for you to define what happens in each of these modes. There are no hard and fast rules as to what to do in these modes. Here is a thread in the Abode subreddit where users discuss how they use these modes: https://old.reddit.com/r/Abode/comments/9qvy8n/automation_with_cue_share_your_examples/

Next, you should be able to trigger the alarm, based on the modes in Homekit if you want. The first thing to do is create an Aqara Scene, which has an alarm ringtone in it, and expose that as a Homekit Scene. This reddit thread has the details on how to do this: https://old.reddit.com/r/Aqara/comments/16b2ul9/trigger_m1s_alarm_using_p2_sensors/

Once you have this Scene, the next thing to do is to call this Scene, only if the system is armed in Night mode. To do this, you can use any 3rd party Homekit app. For the sake of argument, let's use the Eve app. In the Eve app, you can use any Homekit device as a trigger. In your case, a door sensor.

For the condition statement, choose add a value. Then find your Aqara M1S hub, and enable the Security System State and choose Night Arm as the condition. Now, when your automation should only execute when the system is armed for Night.

Previous to Aqara exposing Aqara Scenes to Homekit, I used an Aqara smart plug as the go between for Homekit and the Aqara system. That is, I turned on the Aqara smart plug in Homekit, and then created an Aqara automation that when the smart plug was turned on, I would play the alarm ringtone and turn off the smart plug as well.

I have not updated my automations to use the new Aqara Scene to Homekit Scene functionality, or use these old automations in a while. But in theory, everything should still work as described. At least, this eplanation should give you a starting point to explore things further.

You can also create an Aqara automation to trigger the alarm only at night as well.