Many of your criticisms revolve around the battle itself, in some ways that's fair and in some ways it's not. I doubt either of us is a strategical expert where an army of men fighting a massively overwhelming army of undead is concerned. But I will grant at face value some of these things don't make sense. Like the Doth'raki charge at first I had trouble with myself. But then I think about things a little. Honestly what are Doth'raki good at and what have we only seen them do for the entirety of this show? Ride in full throttle on their horses, which is literally what they did again. I'm not even sure how a cavalry like that is meant to work against that undead army anyway. You can't really flank a force that is large enough to completely surround you anyway. You can't just go in and come back out because they just swarm you, which they did.
The siege weapons, to my understanding, are normally a "shock and awe" type of weapon. I doubt they expected much use of these because this isn't an enemy that you can "shock and awe". In order to get sustained use of them even you'd have to keep the enemy at a certain distance and not have your own in danger, which obviously wasn't possible. In retrospect it actually makes sense to have them ahead of the lines in order to make it easier for them to retreat back to the keep, which they had to do fairly quickly either way.
Bran's use of warging was clearly to incite the NK, which more or less succeeds as up to that point he was shown clearly to be hanging out on the periphery of the battle and not engaging personally, which in order for their plan to work relied on him getting close enough to engage directly.
I could keep going if I wanted but this gets tiring after a point. Like I said, it's fair to see things at face value and not see the sense on it, but if you try you can probably figure something out, which is to their credit honestly. Some people like to be fed every little bit of minutia, some are fine with some being left to the imagination, or piecing things together. Nothing wrong with either. But it's just lazy to just lay criticism down and not at least put some thought into it, that's all I'm saying.