Better not use hot glue, but if you MUST then don't insert the card while you do, and use -very- tiny amounts, (use a toothpick) and only on the four places where you otherwise would be soldering the metal to the pads on the board. Try fixating the metal in place precisely with sellotape before adding minuscule drops of glue to the edges of the metal lips, so the glue will wick under it. Too much glue and you will make matters worse. not glued on straight and it won't work.
Also Cyanoacrylate fumes are poisonous, and soldering afterwards also won't work anymore due to the glue, so you can't later try soldering. Meaning
be sure that you cannot solder it back on, as once you try superglue, and it fails that is it.....
if all else fails, you can try to press the card onto the contacts and hold it in place with a clothespin, the ones with a metal spring.
