To the best of my knowledge 'red' Loctite isn't for threaded parts - it's bearing (or similar) retainer.
Threaded Loctite retainers are:
Purple - low strength & easy disassembly.
Blue - medium strength, disassembly possible without heat.
Green - studlock for permanent fixture, disassembly possible with heat.

The green studlock would be my choice.