XIAO_BLE wakes up from System_ON_Sleep and Writes weather data to on-board Flash

Do you mean after sending the command 0xAB, there is no change in the operating current and the flash also does not respond to further read/write operations?

0xAB is also a command to read the 8-bit electronic ID, below is not the exact code, just for illustration only:

SPI.transfer(0xAB);
SPI.transfer(0xFF);
SPI.transfer(0xFF);
SPI.transfer(0xFF);
byte id;
id = SPI.transfer(0xFF);

Could you verify if the flash accepts the command and returns the ID (0x14)?