The protagonist is a wolf for large portions of the game, during which he can die just like usual, but these deaths are non-canonical and non-permanent, as video game deaths tend to be.
At the start when you are in ordon village once you get the slingshot you are forced to shoot a spider that's hanging on some climbable ivy. In the forest temple and temple of time there are enemies including a boss who are spiders.
In snowpeak white wolves come out of the snow and try to attack link but if you're fast enough you can run away from them
This game and said franchise is safe from sexual assault. I will warm in breath of the wild and tears of the kingdom, the great fairies (they are used to upgrade your armor) do make questionable advances on link. But it is not full blown assault.
There's an escort mission where you have to prevent a carriage with two people inside from catching on fire. If player doesn't put it out in time, the carriage burns. It isn't graphic and doesn't show the characters being burned, but they scream if it catches on fire.
In the last section of the twilight in lanaryu province the only way to get down to lake hylia is if you jump off the bridge, the player survives though.
Yes, a parent does die. Once you've gotten a good chunk of the story done and you thaw out Zora's domain, you are visited by the Ghost of Zora Prince Ralis' mom, Zora Queen Rutela, who tells you of her fate of being executed and asks you to take care of her son.
All the children from Ordon village are either visibly being kidnapped, or implied that they're kidnapped. Link also gets kidnapped at one point in the game. Colin is kidnapped a second time later in the story.
There's a cutscene where a doctor is brought in to look at a sick Zora boy, and one area of the game is the hospital where the doctor NPC usually stands
In Ordon Village, the character Uli is heavily pregnant and mentions she's due "any day" when Link (the player) has to retrieve a cradle for her. However, no harm comes to Uli or her baby at any point in the game. Also the character Malo is modeled to look like a baby/toddler, and might be upsetting for some people, especially since Malo is one of the children abducted at the beginning of the game.
Although I cannot tell if it was intentional, minor character Dr. Borville, having a large nose and being greedy, could be easily read as an antisemitic stereotype.
Not really. This is legend of Zelda, so it’s very tame on sexual content. But midna is a tiny girl practically nude. Other than that, all of these games are safe from sexual content.
(SPOILERS)
A post-credits scene shows Midna shattering the Mirror of Twilight before entering the realm, seperating the connection between the Twilight and the Light realms permanently.
Often overlooked, but Rusl, One of the villagers of Ordon was severely injured with blood on his bandages and face for when you visit his home after transforming back to Human Link for the first time.