The image of a dead fish evokes feelings of dullness, lifelessness, and lack of excitement.
It's a playful way to express that something is so uninteresting that it's like receiving a dead fish in the mail - you wouldn't be thrilled to open that package.
For example, you might say: "That movie was dead fish in the mail. I couldn't wait for it to be over."