Thanks for taking the time share your script.
Expanding on Gary's points you could eliminate all the JOINS by using something like this:
db_name() as Database_Name,
name as Trigger_Name,
OBJECT_NAME(parent_id) as Associated_Table_Name,
OBJECT_DEFINITION(object_id) AS [Trigger Text]
is_disabled = 1;' --disabled