It’s just a standard warning when loading scripts in wow for the first time. Macros can trigger the warning too. It’s a good thing. You should be aware where you get your addons from.
The script is just a macro and it can only do what the API allows. No automation is being done.
PS. From what I read and what made Blizzard start posting the warning, was because of a user made custom script for Weak Aura that made it possible to stand near a mailbox and unknowingly send gold without the players knowledge. This was fixed years ago by the Weak Aura devs. and I believe Blizzard made changes to the API too so it’s not possible anymore.
Also I’ve been no lifing it here since 2008
To your question. Yes it’s 100% safe. No bans ever.