Text Modules are not available within the Backend.
The :: functionality in the backend changes from Text Modules to available system variables of Zammad.
Personally I think -if you need to use text module text within triggers- the better way would be to copy the text modules content into the trigger. I mean the text module shouldn’t change too often, right? :-X