When that Mass. tornado touched down on the Conn. River,was it then a waterspout?

Yes, it doesn't matter where it was formed. On land they are tornadoes, in water they are waterspouts.