Joe, I think you have it. The song was originally French, but became Spanish as well. Mambrú is a corruption of Marlborough, "Juan Churchill," of the European coalition who fought the French.
There are many verses (coplas) to the song.
Your children's version is different from the one sung in Spanish-American schools, which I will post. No idea of the Spanish. (Yours is from an Italian website).