Earthing provides a path for fault currents, tripping a breaker in the event of a fault, that is better than the fault causing the case to become and remain live. However, there is still a brief window between when the fault makes the case live and when the protective device trips. Furthermore, earthed metal can act as a "second point of contact" for a shock originating from another peice of equipment.
The idea with "double insulated" design is that the equipment is designed such that a fault making the case live is "very unlikely", with the result that there is no reason to, and possibly a detriment from, earthing the case.
How well that works in practice depends on how good a job the manufacturer and installer have done to render faults to the case very unlikely.
For a metal cased item "double insulated" design generally means that individual conductors carrying hazardous voltages should not be in a location where, if they came lose from their terminal, or if their insulation failed, they could come in contact with the case. Sheaths, barriers, terminal boxes or similar should be used to prevent that from happening.
What all too often happens is that the manufacturer provides a small terminal box inside the light. This terminal box is designed to provide cable restraint for the supply cable and enclose the connection such that the individual conductors, even if they were to become disconnected or their insulation were to fail, cannot come in contact with the enclosure of the light.
But in a typical UK installation the installer is faced with not one but three cables coming out of the ceiling, furthermore the outer sheath on said cables is often stripped back so it is flush with the ceiling. The terminal box is usually too small to take three cables and even if it was big enough, there is often not enough usable length on the cables.
So the light ends up being installed such that individual conductors with only basic insulation are exposed inside the main body of the light fitting, as are additional terminals with no sub-enclosures or cable restraint. At that point the fitting can't reasonably be considered class 2 anymore.
There are also some fittings that are sold as class 2, but simply fail to meet class 2 standards even if installed correctly.