I had the same problem again with my current sim, only in reverse. This time there were no fishing spots for three-eyed fish in the dystopian future. It made me wonder if it was broken in my game, so I started a test game with a different sim in a different town, and when I sent her to the dystopian future, the debris piles were present on the water. So I did further test runs at other points in my current sim's life, and discovered that after she bought her house in OL, the debris piles for the three-eyed fish would never show up in the dystopian future, even if I sold the house before she changed the future to dystopian and returned. So I returned to the save where she first arrived in OL, and started over from there.
She went through most of the first opportunity chain, but when the step came where she was supposed to excavate a dig site, there were none. So I sent her home then and had her change the future with the time remote control and return. I sent her fishing as soon as she got there, and she has now successfully caught six three-eyed fish. So I guess she needs to go to the utopian future now, so she can catch rainbow snails before she buys her house in OL.