is it possible to load a custom destination in Airbyte managed version?

Yes, it is. You can add custom sources and destinations to open-source managed version. This isn’t possible in Airbyte cloud for now.

Thanks so sounds like for testing I would need to continue using OSS

Yes, the custom connector is in cloud roadmap for next week octaviaparty