For an animation, I have had issues with some programs not reading Blender’s output when I’ve saved a video file trying to use transparency. The way I worked around it was outputting the transparent PNG images for each frame and then using another video editor (I forget which, but probably was either Hitfilm or DaVinci Resolve) to composite them into a video format with transparency that I could use.
