A Flapping Fish will be replaced with a Rotten Fish if it is left without ice in your inventory for too long. Other than being sold for 1 gilda, it is essentially useless.
Attempting to use a Rotten Fish to gain access to the Back Floor on Shipwreck will result in an animation of the Junior Chief rejecting it.
This article is too short to provide more than rudimentary information about the subject. You can help the Dark Cloud wiki by expanding it.