And your question is.....?
Obviously, the appeal is that it's right on the water. The listing says it needs TLC. And clearly, from the photos, it does.
With large ships using that water, I doubt that swimming is the big attraction. If you're correct that the water stinks in that area, that's a problem, but one that potential buyers (and their agents) should be able to detect.
Different people like different things. And for those who want to be on the water, that property could be attractive.