Welcome to the Airtable community!
Automations trigger even if you are not using the app. The problem is with your formula field for the view filter. The
NOW() function updates more frequently when you are active in the app versus when you are not in the app. When you are not active in the app,
NOW() can take an hour or more to be recalculated.