From Game of Thrones, S08E03, now I'm not a military expert, but I think the Dothraki's attack was obviously pointless, so why did they do that?
Against such an enemy every move should be perfect and wise, not based on simple reasons or emotions. Jon and others knew their enemy isn't normal. Jon even described them very well (S8, E2):
Our enemy doesn't tire, doesn't stop, doesn't feel. We can't beat them in a straight fight.
If that attack wasn't a straight fight, what was that?!
Losing the battle was equal to the end for the living. If they did that against, say, Cersei, it would have been okay I guess, but not against Night King.
Almost all great war commanders and warriors were there (also the most intelligent), Jon, Jaime, Jorah etc., so which one suggested that attack? For what reason and goal?
We all know for a fact that none of the characters in the Winterfell knew about the return of Melisandre, right? So they planned the Dothraki's attack with a weapon that has no effect on Wights? (without that fire, Arakh could not kill Wights)