That's what's so odd about it - the final shot of the second season, and the impression they want to leave you with for a year, is the captain of the Enterprise on the brink of crying while Una tries to force him into action.It's called a cliffhanger.
Similarly, they could have written the BoBW cliffhanger as Riker looking horrified with the sound of his bowels emptying in terror playing over the end credits sequence, but instead they end with him giving the order to fire, because they want to demonstrate that he's prepared for command. I'm not sure what similar message we're meant to take from Pike's petrified look as the crew yell at him.