A transparent asset contains an alpha channel that describes which pixels are visible. That is different from a picture of a checkerboard. If you downloaded a screenshot showing a checkerboard behind a logo, those squares may be ordinary visible pixels. Saving that screenshot as PNG will not remove them. Open the real asset in an editor and check that the background can actually show through.
This workflow is useful for an existing cutout, raster logo or overlay that needs a smaller delivery version. It cannot identify a subject, erase a background or replace a badly cut edge. Make those edits in the original design first. Keep an editable master and export a transparent PNG from it, then use this page when you need a different raster size without deliberately flattening the background.