No. The issued the NOTAM about the training area because there was a P-3C out of Brunswick doing some low-level maneuvers in the area. The P-3 was in the area because a U.S. nuclear sub was transiting the area on it's way to New London and it was common for the Brunswick crews to take advantage of these rtansits to practice tracking subs in real life. If the Navy at first denied assets in the area then it's because they don't like to announce the comings and goings of their subs. Kind of shoots the whole 'stealth' part of their activities right out of the water. So now your questions were answered.
Besides the Navy being in the area, doing something or other, we have a Coast Guard. Certainly a missile fired from the water close to our shore, should arouse their interest. So far as I know it did not.
What Coast Guard assets were in the area and why should they have been on guard for a terrorist missile launch?
Check out the Coast Guard's mission. Pay special attention to the parts about Maritime Security and National Defense. The Coast Guard not reacting is sort of like police doing nothing after learning of a bank robbery.