The best response regarding the tone of a story is: It should remain consistent from beginning to end.
While tone can enhance themes, create suspense, and might have slight shifts in some narratives, maintaining a consistent tone is generally important for the overall coherence of the story.