I seem to remember this coming up a few times pre-Sonoma, so it may be a Dropbox update or setting and unrelated to Obsidian.
https://forum.obsidian.md/t/obsidian-permanent-deletes-files-system-trash/46409/8
Also, respect to all you brave souls updating macOS right away. 