I felt real emotion when Pike died, unlike the later scene, partly because I was laughing so hard and partly because they had already alluded to the reset button. They needed to cull him to move the plot and characters forward. Pike's death worked IMO.
Just wished he could have made it to the 3rd movie loved to see him sacrifice himself..... I thought it worked better in Man Of Steel superman lost his foster father and his real father in that movie but I thought the Kevin Costner scene was emotional when he saved his dog and would not let Clark save him to stop him revealing his gifts. I'd loved to seen pike save kirk and kirk realise that he was right all the time !!!