Derived from the obvious lack of enthusiasm and energy of a dead fish caught out of water, being or feeling like a dead fish simply means that you just want to crash in bed and hibernate until you regain your energy and are capable of performing basic functions. Until then, you are a dead fish.
-Want to do something tonight?
-I can't; I'm a dead fish. Was up all night yesterday.