Happened a couple of times, that my general died in auto-resolve. But usually in the really big battles where the balance of power shows your army's weaker but you still win.
Sometimes also if he was an unexperienced general.