There's hundreds of years (if not thousands) of shipwrecks, from which we can interpret their effect on the underwater environment.

Unless there are pollutants involved, the wreck is generally a net positive for biodiversity and provides an attractive area for marine life.