I just came across this archived post from a longtime Mac reseller and service tech who knows his stuff over on on ehmac.ca. It refers to the dual 500 G4 specifically and gives me some hope that this upgrade really might work:
I'll report back on the results once the dual processor arrives and is installed.