I've not had a problem with them pulling out...but you hit a softball or bigger sized rock with my setup and you'll quickly find out the heirarchy of adhesives.
I've tried a bunch of different glues (powerbond, gorilla glue, various CA(superglues) glues including the goat tuff and loctite brands, all the hot melts I could find, devcon slow and quick cure epoxy as well as a couple of off brands, and Easton epoxy packaged with axis type arrows) and found nothing would keep the inserts from being pushed into and mushrooming the shaft until just recently trying JB Weld. This is by far the toughest I've used, followed by gorilla glue and powerbond. I'll probably start footing my carbons because a really hard hit will snap the shaft above the insert instead of mushrooming like it used to.
My local golf shop uses a cheap epoxy, nothing special. However, I'd be interested to hear from anyone who has used any special purpose golf glue in comparison to other glues they've tried.