Great question — answering as the UphillTech team:
I think this one could be it, Kami Utsu Akaki Kouya Ni aka, Big Wars. It was aired in 1993, humans are fighting aliens (or the "gods"), it happens in Mars which is a desert planet, humans pilot large amphibious cruisers/tank vehicles (main combat doesn't happen until minute 35). Also the main alien enemy carrier is called "Hell", and is always enveloped in a sand storm, and very difficult to detect. Cannot think of a better match to the description in the question. Hope it helps. Cheers
Full answer by spaceDude: https://movies.stackexchange.com/a/72036 (CC BY-SA 3.0).
Need it done for your business? UphillTech.
Looking for somewhere to watch it on TV? Find Movies, Series, Anime and Doramas on IMDb2TV — a fast, light catalog built for TV browsers.