While 60% is a high figure, much of that 60% would not go out of their way to discriminate against trans folks. I know, that's conjecture, but anecdotally, even in republican dominated areas I've visited, I've found far fewer than 60% of people not willing to refer to me by my pronouns, despite not passing (I'd say it's less than 10% in my experience, but of course different areas can be much better or much worse). And that's recently, during this period of intensely transphobic government. I think there's more nuance to analyzing the results, hence why Pew said it's a seemingly complex topic. I believe much of that is simply ignorance; lack of education on gender. That would be one possible explanation for the discrepancy between those two questions. But what I've experienced in my own life, having been here since I was born, is that nowadays, visible transphobia is still not the norm (not a majority opinion), hence why I'd consider it radical. I can't analyze the inner thoughts of everyone I interact with, but most people I have simply used the name and pronouns I gave them without question (albeit with occasional—almost exclusively accidental—mistakes). Granted, I must admit that I rarely interact with people who aren't Gen Z or Millennials, and I can imagine the experience would be much different with older people, as polls frequently show significantly higher acceptance among younger populations.

Now if you want to talk about microaggressions, the picture is a lot muddier. But I can only really comment on what is obvious to me.

EDIT: I think the best way to describe it is that most people just don't care. Now, it's different when it comes to employment and housing—that's a dumpster fire. The unfortunate fact is that people who control housing tend to be older, and also tend to heavily lean Republican, both of which dramatically increase chances of discrimination. Despite laws against housing and employment discrimination on gender identity in my state, it's very clear that it's a huge problem, hence why I am applying for housing and employment under my given name, and won't be changing my legal name until after I'm financially secure. People in positions of power tend to be far more discriminatory than the average person, especially when housing and jobs are stretched so thin.