Suicidal Generals is one of the in built problems in MTW2. There are measures that can be taken to modify the BAI but I'm not sure the problem can be removed entirely.
The AI for Kingdoms of the Isles is one area that requires a lot of work still. Increasing the HP will of course help generals survive but not prevent them from getting into trouble in the first place!