Sure, that was always part of the problem... but if you intend to keep a device on any extended periods of time, power failures are a reality you have to face. (and it's silly to think about spending the money it would take to put a reliable UPS in front of a $35 computer.)
Also the problem is more than just file system corruption... it seems to actually damage the flash. My 3B has pretty consistently destroyed any card that's mounted if the power goes down unexpectedly -- any further attempts to read or write the card even on other devices end up in a death spiral of bad blocks and hardware errors.
My approximate understanding is as follows:
Consider a high end, proper consumer SSD. Cheaper ones may lack some of these features, such as supercapacitors, DRAM etc.
Behind the scenes, it has many data protecting / preserving mechanisms.
Such as a supercapacitor, so if the power suddenly disappears, it can finish all writes and flush any cached write data, to the disk.
A sizeable DRAM, so that if the same sector is continually updated / changed, it can update the DRAM copy, without wearing out the flash.
A powerful processor and / or controller chip, whose extensive firmware can attempt to detect bad sectors (data), then correct it (moving recovered data, to a good sector) if possible (e.g. small number of bit errors), or failing that. Reliably mark it as unreadable, hence at least allowing everything else to work as normal. Unlike much simpler microSD cards, which under similar circumstances, may just crash or have lots of errors.
Also microSD cards, seem to be design and built to a bare minimum cost. So can have poor cooling and lack many SSD features.
In other words. A microSD card is not the best of choices, to use as a ‘HDD’ (SSD).