Well MM seemed to be the game that had the most death... Butlers son, Deku scrub that Skull Kid kills, Mikau, the goron... except you don't see them get killed but you do see Mikau die. In
TP there was Rutela who died, but you don't see her execution. So at least death itself = isn't absent from Zelda games thankfully. But yes I would like to see a main character die... More emotion please. Actually imagine if Ganondorf had killed Midna at the end of
TP... that would have made me literally cry and I actually did feel like crying already.
I think Nintendo should grow up when it comes to the console Zeldas. Why? Because their fanbase has grown up. They can support the little 8 year olds with the handheld Zeldas... all the kids seem to play handhelds anyway. Well most of them...