Eh, steel manning the role it kind of just sounds like a TPM. When roles are crisply defined, a good TPM has been a life changer for my job satisfaction. You basically get permission to farm out a lot of the most annoying parts of the job--status update forums, timeline management, and dependency wrangling--to another person who does it full time.
I've seen both versions of these. A good TPM is extremely valuable though, especially for work that is highly reliant on coordinating other teams. The bad version was a net negative to team productivity.
My first SDE job was in a company with a dedicated Scrum Master role, and they were basically the lubricant to make Agile/Scrum teams fit into what was essentially a waterfall environment. It's roughly a TPM in Big Tech, but without those companies as industry peers for setting comp.
Weird that some companies have a dedicated role for that. My current gig doesn't talk about agile at all... we still have two week sprints and self directing teams and all of that, just none of the annoying buzzwords