Do all species become extinct

No. While some individual species might become extinct, fish as a whole are in no danger. There are many fish species that we do not fish for. Assuming we don't sterilize the planet in a nuclear war, fish will be around long after humans have disappeared.