Photos Library cannot be opened after Mac OS Sonoma 14 update

After updating to Mac OS Sonoma 14, the photos app returns the below error.

Photo library in icloud will not open

Photos Library.photoslibrary” is in iCloud Drive, and needs to be moved to a folder on your Mac to open.

A google search led me to a thread here which indicated the below steps would resolve the issue and photos would continue to sync between iPhone and Mac as they had prior to the OS update.

Steps followed from the other thread are below. After moving the photolibrary file as described in step 2, the Photos App will now launch, but photos and videos are not syncing from my iPhone to Mac as they had previously up until two days ago when I updated my OS. This seems like a defect or a big step backward in functionality. I see there is another OS update available for Sonoma 14.1. I am hoping the update fixes this issue as it's a huge pain for me and seems like many others.

Step 1:

a. Open Finder

b. Look on the left side for "iCloud Drive" and click that. You should now see a list of folders and files to the right.

c. In the list of folders on the main (right-hand) section, look for Pictures and click that. You should now see a list of folders and/or files that are in the Pictures folder.

d. Look for a file called "Photos Library.photoslibrary". Depending on your settings, it might just show as "Photos Library".

e. If you see this file, you have successfully completed Step 1. This is where all your photos are stored locally.

Step 2:

a. Open another Finder window (from the Finder menu at the top of your screen, choose File and then New Finder Window)

b. In the left pane, look for "Pictures" under Favorites. If you don't have that, look for Macintosh HD, then choose "Users", then choose the folder with your account name, then look for "Pictures" under that.

c. The Pictures folder you found is where you want to move your photo library in the next few steps.

d. Position both Finder windows so that you can see the Photos Library file you found in step 1 and the Pictures folder of both on your screen at the same time. Resize them if necessary.

e. Move your cursor to the Photos Library and click on it once to select it. Then click and hold so you can drag it. Move your cursor a little to make sure it's getting dragged.

f. Drag the file over to the Pictures folder you found in the other window, and drop it into Pictures by releasing your mouse button (or raising your finger on the touchpad).

At this point, you'll get a warning about the file not being available on other devices. Don't be alarmed; this file is only local storage so you really don't want it in iCloud anyway.