Certainly there is transparency.
If there is only animated text on a transparent background, it does work. I use the result (in Prores4444) in FCP on a video layer.
If only the first frame fully covered by an image, AE forgets to render transparency.
Grtz, Henk