According to support article, Apple Configurator fails to add apps to iPhones and iPads. Apple suggests that issue will be resolved in next update.
As of now, Macs used for device management should not be updated to macOS Sonoma.
Apple Support: If you use Apple Configurator to add apps from the App Store to an iPhone or iPad
Reference: Apple Configurator Issue Will Be Fixed in Future macOS Sonoma Update