The current for LightSleep using sleep() is 60uA, and also 60uA when simply delay().
This is a far cry from the 5uA of EM2 LightSleep you got.
Maybe the Sleep() in the XIAO_MG24 BSP is not made with serious consideration of current. Or maybe it was designed to wake up from any trigger source.