Perhaps the ssh tunnel is not sufficient for the supercomputer nodes to be able to access your MongoDB server. (BTW, Fireworks will need read/write access to MongoDB for the entire workflow run.)
Try setting up your LaunchPad on MongoDB Atlas servers and my_launchpad.yaml files that point to it.