natoal Do apps in PixelOS and GOS have sandboxed storage access? And if so does that mean that no other programs except admins may access the contents of their directories?
Only the app itself can access its app data. No other app can, nor you as a user. If an app opt-in to backup support, the built-in backup app can access the data, but otherwise no other app can.
Apps can store files so they are accessible to other apps, if they want. If they do, the files will show up in the Files app. You still need to grant that other app access to that specific file though.
natoal I understand that currently even in GOS, Private Space is not encrypted at rest after first unlock
True, the encryption key for the private space will remain loaded in memory after the private space has been unlocked, until you reboot your phone.
This does not mean apps outside of the private space can access data or files from within the private space, they cannot. Unless you as the user specifically choose to share the file into or out of the private space using the system file picker or share functionality.
natoal I was wondering how difficult it would be to program a barebones notes app that was both sandboxed and encrypted at rest.
All apps are sandboxed. All app data is encrypted with the encryption key for the current user profile, but this is to prevent someone with physical access to your phone and advanced forensics tools to access the data, not to prevent other apps from access it, other apps cannot access it. If you need encryption for this app specifically, you can put the app in its own user profile, and reboot the phone once you have finished using the app.