The water had seeped into the normally dry rock field beyond the Mission Point Lighthouse near Traverse City, Michigan