Looks like we’re both trying to do the same thing! Automations triggering mode switch only in certain modes doesn't work in new ST app
Try what @Automated_House suggests in that thread–remove the location mode change from your scene, create the automation, then add the mode change back in. That’s not how I fixed my issue, but based on how I understood the help I got it should fix yours.