Hi!
This likely happens because the Discourse backup process runs with effective user ID 0, thus you will likely need to pass this option to sshfs:
sshfs -o allow_root SERVER:PATH MOUNT_POINT
Or if you’re using unprivileged containers, allow_other instead.