In order to make the export transparent export out as Quicktime Animation set to Millions Color +. Or Pro Res 444. They are the only video codecs that support transpancy.
You can also just bring the project file direclty into Motion and it will remain transpent.