A workaround. Go to settings/wallpaper/your chosen Photos Album. Eventually (can take a while) your photo albums will list and there will be a thumbnail of each photo in the album. The first thumbnail is the non working 'cycle the album' activator. Any photo you click on becomes the wallpaper. Now keep clicking successively on as many as you want. Now go back to that first activator thumbnail and click on it. All photos you clicked will now cycle. I have 4100 photos in my 'wallpaper' album, but only have about 200 cycling. Good luck.
PS How many Sonoma updates do we have to wait for before Apple addresses this BIG FAIL. I think with 14.2 we have had 4.