Make sure you have script mods enabled in Game Options -> Other. Also make sure the .ts4script file is on the root of your Mods folder and not in any subfolder.