That's probably a pretty accurate assessment. WIth the kennedy name it will most likely end up in MA as a floating museum - but it would take up a lot of space and cost a great deal of money to find / create a suitbale location for it in Boston Harbor as extensive dredging would be required.
And then there would be a steady drain of cash to keep it afloat as a museum. Plus the potential security issues with the hull would still be ever present requring security pretty much 24-7. And preventing access by divers in a public harbor would be difficult. The most cost effective option in terms of long term security would be to essentially dry dock it in a coffer dam and then fill it in with sand. And that is something of a less than glorious fate for a ship.
In that regard it makes just as much sense to sink it. Look at the CV-34 - it's heavy enough to sink into what most would regard as a hard bottom and the CV-67 is a lot heavier at 164 million pounds. Put it down on soft sand or mud bottom and the odds are good there will be little of the hull to observe.
Personally, I think it is a bit more noble for a ship to be reefed than laid up as a museum, and the life it attracts is astonsihingly beautiful.
But on the other hand, the Oriskany has potentially become one of the biggest impediments to getting more aircraft carriers reefed. The EPA requirements were stupid in the extreme with insistence on removal of pretty much all PCBs etc. when many of those would have been released very slowly if at all over a period of a couple hundred years. The end result is that no great advantage was gained in terms of environmental protection and the reefing was not cost effective.
To make it worse, it is hard for the dive community to argue that the CV-67 would be a "memorial" when things like the phone in primary flight on the CV-34 disappeared within a few weeks of the sinking. Divers who feel they just have to take artifacts don't help the cause.