Given that this is END GAME content I should highly hope it is possible to fail it.
Jeez guys this is supposed to be the pinnacle of the game and you are arguing over whether these are completable whilst afk, the very fact that that is a discussion shows you how ridiculous these things are
I think you've missed the point entirely. It's not that you cannot 'fail', it's that you need to broaden your concept of failure to a non-binary condition.
Tolkien spelled out exactly what happens in Helm's Deep. When it happens and who is there when it does. So you are never going to prevent the wall from blowing up, for example. But, there are rewards for making sure, by way of exmaple, that no NPCs die before it does. It is entirely possible to 'fail' to do this perfectly. It is also possible to do this "almost" perfectly and still receive some credit for it. But for someone trying for a platinum score on that objective, yes you most definitely failed.