Is it okay to use an external flash drive to store a Photos Library? I'm getting an M1 MacBook Pro from my employer which only has 512 GB of flash storage (my 2018 MBP has 1 TB), so I'll need to move my 350 GB Photos library to an external drive. I know that I could have Photos optimize for storage (I do have iCloud Library), but I think it's best to have the full-size Photos library stored somewhere.
Would it be okay to store the Photos library on an external thumb-type flash drive from a reputable manufacturer such as SanDisk, or should I stick to a more conventional external USB flash drive, such as the SanDisk Extreme series?
There is Apple support document Move your Photos library to save space on your Mac where among other things are stated:

To prevent data loss, Apple doesn't recommend storing photo libraries
on external storage devices like SD cards and USB flash drives, or
drives that are shared on a network.