Photos is not offloaded either. If you are using iCloud Photos, and have Optimize Storage turned on, then it may reduce the quality and file size of locally stored photos, but it does not offload them. It still holds all the photos locally, just they are reduced in quality while the ones in icloud are full size and quality.
If you are not using iCloud Photos, or do not have Optimize Storage turned on, then the Photos are stored locally in full quality and use the same amount of space.
click here ➜ Manage your photo storage - Apple Support
Music is a different thing all together. Apple Music can stream music without downloading it entirely when you use the the Apple Music subscription service and its iCloud Music Library option.
click here ➜ Use Sync Library with your Apple Music subscription - Apple Support
Notes, does not reduce the file size of notes nor can it stream note to a device. It keeps all notes and their data locally on the device and syncs any changes to iCloud.