I share this Mac with someone / I use more than one Supernote account. Can they see each other's data?

No. The app keeps each account's to-dos and lists separated internally by account, so switching or logging into a different account never mixes one account's data into another's. The encrypted database is also tied to your macOS Keychain, so another user account on the same Mac can't read it.