Is it okay to use an external flash drive to store a Photos Library?
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.