Photos Library is missing after recent Sonoma 14.6.1 update

After the recent Sonoma 14.6.1 update, my Photos Library is missing from my local Pictures folder (I suspect due to not enough disk space to perform the update). When I open the Mac Photos app, I get the error message "The library could not be opened. "Photos Library" is in iCloud Drive and needs to be moved to a folder on your Mac." And, sure enough, when I open my photos on my iPhone, all my photos are available and when I log into my iCloud account via Safari I can see my entire photos library. Now my question is: how do I move or download the photo library from iCloud back to my MacBook Pro? One similar question/response indicated that they found a Pictures folder under their iCloud Drive icon in Finder from which they could just drag the photo library back to the local Mac Pictures folder (sounds intuitive). I don't see any such Pictures folder listed under my iCloud Drive on the Mac nor in my iCloud Drive in Safari. The photo library is somewhere in my iCloud account, I just can't figure out where it is nor how to get the library back to my Mac.