In Amsterdam airport they are pretty unalarming, just pairs of automatic doors a few paces apart. From a brief look at this video, you have to momentarily stop, and there is a hint that you might not be able to continue. That's just bad usability. The ones in Amsterdam allow you to carry on walking at a normal pace, and they act like normal automatic doors (in one direction). I'm sure there are people who walk through them every day and don't even notice them.

The last time I was in Atlanta, they had a similar thing, but more subtle. If I remember correctly, they have a bank of escalators, but all of the escalators go in the same direction. As I found out when I got to the top, and had to go through security again to get back down...

I often fly through CDG and AMS, and I'm pretty sure that I've gone through them at both. I never found it particularly alarming. You just walk through double doors. As others have mentioned, they often don't even close if there's enough people going through them. They just have signs making it very clear that you can't turn around once you enter them. I am particularly paranoid/upset by airport security, and they've never bothered me. YMMV.

I can very distinctly remember going through these in FRA.

hmmmm I just flew through the Amsterdam airport about two weeks ago and it had this system in the International terminal, except the doors were about 5 meters apart.

It is a bit different especially in feeling. You walk straight through and most people probably don't realise that they are sort of in a trap. With enough traffic flow they don't really shut (although they obviously could if there was some that they needed to contain but I don't know the scenarios it is used).

Because it is default allow the feeling is quite different to the system shown in the video where it feels like default deny and it asks you to wait.