It may have been the "brand" that you used causing issues.
I use this one for machine embroidery. No issues with it and a light spray keeps everything together.
https://www.sulky.com/item/sulky-kk2...ive-42-oz-120g
I have also used a washable glue stick to hold stabilizers and fabrics together for machine embroidery.
Did you try a "non stick" needle?