"Unearthed neutral" is the NORMAL configuration for AC electrical machines, regardless whether they are connected "delta" or "wye". In the case of delta, there is no neutral connection available. In the case of wye, the neutral point is physically located somewhere within the machine winding - but is not brought out to the world at large.
"Unearthed" neutral systems are the PREFERRED network for marine installations (particularly shipboard), since it is disadvantageous to pass current through the hull material (which is the only available "earthing" plane).
Even for rotating equipment operating on power electronics - it is not necessary for the neutral point to be connected directly to earth. However, it IS required that the neutral plane of the machine be connected to the neutral plane of the drive.
We have to separate out the different applications and situations, such as line Transmission systems and site wiring etc.
Neutral wiring should never float, as in being allowed to rise to some dangerous voltage relative to the Earth, people can touch. Normally Neutral should be securely Earthed at or close to source, that is supply Transformer, Generator or UPS. As in TN-C-S wiring systems.
Yes there are some special applications, such as IT systems, where the source Neutral is either connected to Earth through a deliberately introduced earthing impedance or is isolated from Earth. (Quoted from the IEE regulations) But if isolated, then there needs to be suitable protection to prevent the floating Neutral from rising to a dangerous voltage and or compromising the insulation of the live wires to the PE Protection Earth.
By definition, a Neutral wire is a potential Current Carrying wire, it may or may not be used in some systems. PE Protection Earth or Ground wires should not carry current, except when there is a Fault.
In this context, "Earth" and "Ground" and "Tera", are exactly the same thing, so can apply to ships, aircraft, rockets and other planets. Being the mass that people can physically touch. So the Sea and ships hull become the Earth or Ground point.
A TN-C system has a combined Tera, Earth or Ground wire with Neutral.
TN-S system has a separate Tera, Earth or Ground wire from Neutral.
IT system, the source Neutral is either connected to Earth through a deliberately introduced earthing impedance or is isolated from Earth.