Whenever I need to add local songs, I do it in the Apple Music desktop app, then just refresh my iCloud library. It shows up in Cider afterward