I don't mind but it must make things tricky for atheists when choosing schools
Yes it does! But then again, a lot of people don't realise about the act of worship requirement so are either surprised when it happens, or just don't know it's going on.
There's huge difference between schools, in how they interpret this. Some are basically secular in that they fudge the requirement and go for woolly "wonder and awe" solutions so they're ticking that box but not really doing anything that most people would recognised as Christian worship. And, others embrace it.
There has been a bit of kick back to this. Unsurprisingly, many atheists aren't keen on mandated worship. The last time I looked into this in any detail (a few years ago now) there was the possibility of an opt out on the horizon I think, but I haven't kept up with it so I don't know if this happened. And how academy schools fit into this, I have no idea!
When we were looking at primaries, I used a question for open evenings that I hoped would be neutral enough that the school wouldn't know what I wanted the answer to be:
how does the school manage the requirement to provide an act of worship?
It worked: the answers did show the huge difference between our local schools, in their approach to religion.
Good luck, nestisflown, I hope you find a school that works for your family.