It's a bummer, but then Pike's story has an end we've been approaching. Albeit, it was something like 10 years total before his destined disaster, so there could have been a few more stories to tell. At least they have some time to try and wrap things up.
I'm just bummed that the Trek I love most is coming to an end. I have absolutely loved everything about it, even the musical episode (unpopular opinion, I know, but I was a theater kid). I would have adored 7 seasons and 3 movies, but I get that we knew the ending before it started.