There’s also the problem that they didn’t bother to give the Dothraki weapons that could kill wights. That only got fixed by plot drama.
And that’s the underlying issue, really - the battle was very carefully planned to be dramatic. No-one wasted any time on making it sensible.