I was using both the triggers set by the script.
Editing the task manually to run at logon of my user rather than any of them and removing the other trigger seems to have solved my problem.

The logon sound plays even before entering my pin/password/fingerprint.
Is there a way to play it only afterwards, when the system loads the desktop?