Turns out you need a limited engagement timer with the hostile players to be able to activate the auto-targeting missiles.
Yet to get a limited engagement timer with the hostile player in LS and HS, you first need to attack them. Which you cannot do with auto-targeting missiles because of the limited engagement timer requirement.
Chicken egg bug.
Fit a scram on the Avalanche next time as a workaround until CCP fixes this bug.