I mean this is pretty true of any Star Trek series. DS9 from the 90s probably has the widest gulf between grim and goofy episodes; in one episode there’s a war criminal who gloats about committing genocide and getting away with it, and another episode from the same season has the cast playing hopscotch.