That nut is handy to get the pump attached at times. Otherwise, it doesn't do much. I've never paid a lot of attention to how tight it actually is when riding with the tube full of air.
Purple Loctite is weaker than blue. If you want to use some, give it a try next time.