We always had a lively discussion about this in my seminars, some for, some against.
The general consensus after the discussion was usually that we were comfortable if the author him- or herself mentioned triggering content in very tactful and considerate wording at the beginning of the book--but less so when the warnings were added by an outside party, such as the publisher (or, though we never went in that direction, the librarian). Rather than alleviating censorship issues, I can see content warnings feeding right into the requests in certain states for librarians and booksellers to "label" potentially controversial topics. And by adding trigger warnings, is the librarian liable if a student IS triggered by a book that doesn't have a warning specific to his/her trigger? I understand the desire to do this, especially in light of the SEL movement, but it's a slippery--and very subjective--slope that could definitely backfire badly in light of the OTHER book-related movement currently happening. Just my two cents.
Cathy Andronik
Brien McMahon HS (Retired)