I don’t think it’s a lack of foresight, I think it’s simply a case of being stuck between a rock and a hard place. Mance spent enough time accompanying Lord Commander Qorgyle to Winterfell to know the North fairly well, he knows the North is going to fight them.
But worst comes to worst, I think Mance thinks it’s better to die at human hands and stay dead than come back as zombies.