Room shows as "active" even after motion alarms turns off

Because you wrote in another topic that you also use Aeotec Door and Window Sensor, I guess that one of these sensors is responsible for your Flow not working the way you want it to.

Copied a post regarding Zone Activity here as info:

Acc. the Using Zone Activity support article, Zone Activation can be used with motion and door/contact sensors only:

The Homey SDK documentation also states that only devices with the alarm_motion and alarm_contact capabilities can be used for the Zone Activity option:

(Source)