This is very unusual for Cupsogue and/or Smith Point or any other south shore beaches.
Waterspout off of Cupsogue Beach moving towards Smith Point
Credit: Bob Brown, Manorville
A waterspout is an intense columnar vortex (usually appearing as a funnel-shaped cloud) that occurs over a body of water. Some are connected to a cumulus congestus cloud, some to a cumuliform cloud and some to a cumulonimbus cloud. In the common form, it is a non-supercell tornado over water.
While it is often weaker than most of its land counterparts, stronger versions spawned by mesocyclones do occur. Most waterspouts do not suck up water; they are small and weak rotating columns of air over water.
Waterspout over Fire Island at Mastic Beach
Funnel cloud over moriches
Off of Cupsogue Beach moving toward Smiths Point.
Bob Brown, Manorville/