Please fill out the fields below so we can help you better. Note: you must provide your domain name to get help. Domain names for issued certificates are all made public in Certificate Transparency logs (e.g. https://crt.sh/?q=example.com), so withholding your domain name here does not increase secrecy, but only makes it harder for us to provide help.
Your question doesn’t make any sense, because you keep bring DNS into it–DNS has (almost) nothing to do with SSL, certificates, issuing certificates, etc. But no, there’s no sensible way* to “remotely point to my site from another hosting company with an SSL certificate.”
This link makes it sound like Moonfruit doesn’t support SSL at all. This is mind-bogglingly stupid in this day and age. I’d strongly encourage you to take your web hosting business elsewhere, perhaps to one of the hundreds of web hosts who support Let’s Encrypt out of the box, rather than to continue to support such a customer-hostile provider.
*Sure, there are ways that are not sensible. You could set up a reverse proxy at some other host, and use that to proxy the content you have at moonfruit. It would give your users the cherished padlock, but all the traffic would still be traveling over the Internet in cleartext.