"IIRC there are at least three different numbered operations areas in that area."
There are no 'operations areas' in the Long Island Sound. "Operations Area" isn't even a term the US Navy Uses. The release of live ordinance in the United States is HEAVILY regulated. It takes weeks, sometimes even months of planning and it can - BY LAW - only happen in very specific designated areas. Here's a list of all the Danger Zones and Restricted areas currently codified in the CFR.
https://www.govinfo.gov/content/pkg/CFR-2019-title33-vol3/xml/CFR-2019-title33-vol3-part334.xml
The vast majority of those listings are restricted areas surrounding sensitive installations. Some of the listings are actual danger zones/impact areas where live-fire tests can be run. Depending on the site, these can be small arms tests, naval or army artillery test sites and some are missile tests sites. There are only four or five missile tests sites in the territorial and adjacent waters surrounding the contiguous United States; The Eastern Test Range (Cape Canaveral) where the VAST majority of all eastern seaboard missile tests are conducted, the Atlantic Test Range which is located off the coast of Virginia in the Chesapeake area, White Sands, Point Magu, Vandenberg and China Lake. There are no missile test ranges ANYWHERE near the Long Island Sound. Why? This is why...
That's a screen shot of the FlightAware software from 0800 this morning. We don't test missiles in the Long Island Sound because it's full of aircraft traffic and even more marine traffic....
Testing a missile or naval gunfire of any kind in the Long Island Sound would not only be laughably stupid - see maps - but it would be a violation of US law, something any officer in command of a ship would fully understand. If a captain of a ship tried to launch a missile in the Long Island Sound, he would be ignored. Why? Because it wouldn't be a lawful order and officers are obligated by law to only follow lawful orders. Again, it absolutely shocks me what people who have no military experience will believe about how the military operates.