Do you have a bb lockring? with that, assuming it's tightened enough, the cog isn't coming off even if you don't have any loctite at all. Way more likely that the threads will eventually strip.