That's quite a sight to behold. Some old Canadian destroyer escorts have been sunk like that to form reefs over the last decade or so. There's one down province, just outside of Lunenburg harbour, and a few of them rest in the waters around the Gulf Islands, between Vancouver Island and mainland BC.
I can imagine a few of the old fellers who crewed or flew from Oriskany probably felt some slight pangs of sadness to see her slip below like that. When you have fond memories of a ship, you can't help it.