You uploaded just the VPJ file, which is of no use. Please follow the procedure above ... the VPJ and all source files will be part of the folder to be uploaded.
The .apng is indeed transparent when loaded into Videopad, assuming that's how you plan to use it. It also opens in MPC-BE, with a black background.
You mentioned that this once succeeded. Where? In Videopad? If yours is a still image, just 'grab' it with a right-click on the preview window.
Here's an .apng video for testing. Download it and give it a try. You should see that it works fine as an overlay in Videopad.