According to the Macquarie dctionary, "puissant" means mighty or powerful, which is a bit different from the colloquial usage of "pissant."

The Macquarie refers to the use of "pissant" for a drunk, but my understanding of it has always been that it referred to people who would be if they could be.