Hi, Brandon
The scp command should run in your local machine, not your discourse server.
Your command should like be this…
brandon@your_machine_name# scp /Users/brandon/Downloads/my-forum-2023-05-17-011157-v20230510142249.tar.gz root@{{your forum ip}}:/var/discourse/shared/standalone/backups/default/