Why is a PNG appearing transparent in solid view but not in rendered view?
You don't need the color as transparency,
and you don't need the last set of nodes.
Why would you have black transparency? It will make it opaque.

The  mix with a transparent shader should be at the end of the node chain.
Or you can just use the alpha input on the principled shader, as noted on the other answer.