The origin of the name, for families of Hispanic origin living in Cuba, may be as you say.

However, Cuba, or even Spain, hardly have exclusive ownership over the name of Pupo.

It is a common surname of Pedace, Cosenza, province of Calabria, Italy. That is in the boot, southern Italy. It likely exists as well, in other parts of Italy, but that's beyond the scope of my immediate research.