Before You File a Bug Report Please Confirm You Have Done The Following...

• I have tried restarting my IDE and the issue persists.
• I have updated to the latest version of the packages.
• I have searched for related issues and found none that matched my issue.
• I have read the FAQ and my problem is not listed.

Playground Link

https://typescript-eslint.io/play/#ts=5.6.2&fileType=.tsx&code=MYewdgzgLgBAZiEMC8MAGAoGMoAsCWEMuAhkVAE4n4A2%2BYA5jAO4FQCmEADicOwFwASAN4BybNlEBfDGgDcQA&eslintrc=N4KABGBEBOCuA2BTAzpAXGUEKQAIBcBPABxQGNoBLY-AWhXkoDt8B6Jge1tiacTJTIAhtEK18iALbF4QifQAexaIMocm6KAHcRG8GAC%2BIA0A&tsconfig=N4KABGBEDGD2C2AHAlgGwKYCcDyiAuysAdgM6QBcYoEEkJemy0eAcgK6qoDCAFutAGsylBm3TgwAXxCSgA&tokens=false

Repro Code

const foo = `
  this has trailing whitespace:${'    '}
`;

ESLint Config

module.exports = {
  "rules": {
    "@typescript-eslint/no-unnecessary-template-expression": "warn"
  }
}

tsconfig

{
  "compilerOptions": {
    "strictNullChecks": true
  }
}

Expected Result

This case should be allowed since it's a useful way of explicitly showing trailing whitespace

Actual Result

This code is flagged by the rule.

Additional Info

It's also really annoying to disable the report. You can't use a next-line disable, since the preceeding line is part of the template string.

Inspired by #10244 (comment)
cc @bradzacher