Kind of the same story here for me.
In fact, automations are working, but only to shut down everything.
I have several automations to turn on the light, color & brightness depending on the time of the day when I turn the TV on, but for a few days, those automations aren't working anymore. The TV turn on, but not the lights. I've tried to find where the issue is coming from, by adding another automation like playing music when the TV turn on, but same issue.
However, I have an automation to turn all the lights off when I turn off the TV during the day, and it's working fine.
Definitely a software issue.
I've deleted, my Homekit TV (LG CX), all the automations, reset my homepods, Apple TV, ... and recreate it again (via the Home app, and as Shortcuts) but nothing worked.
I don't want to delete my current Home and create a new one, or at least if really necessary (and not sure it will fix it as the automations is working in one way...).
I think I'm out of solutions.
If someone has a solution I didn't try, I'll be happy to learn more about it.