This. Watching Honnold makes your palms go clamy and makes you uncomfortable because you imagine how terified you'd be in that position. But for an athlete like Honnold, the experience is more similar to just a "hard hike". Strenuous, but just work. It's just normalized because he does it so damn much. He really seriously is not gonna fall off that building, just like you're not gonna get seriously injured on a class 3 hike.
(Source: I'm also a climber. Not remotely close to Alex's level. But frequent exposure significantly changes how your brain processes these situations)