I think folks need to read the contents of this thread closely.
Numerous Individuals here have stated that they have talked to some level of Apple Support about this bug. They have all been informed that Apple’s software engineers are aware of the problem and are working on fixing it, most likely in the next iOS 17 update.
in the meantime, there are (at least) two methodologies to mitigate this issue until an official patch is available. They are detailed elsewhere, and at this point have been disseminated and can easily be found by searching the web.
I successfully applied the plist modification technique to my iPhone 13 Pro, and now all of my text/notification tones are accessible again, just like they were in iOS 16.6.1.
Peace out.