Longer term, it can turn out quite well. And yeah, I realize that some country changes must be conducted on a very compressed time schedule - I’m fortunately unfamiliar with those.
The other side of the coin is that foreign academics, with maybe the exception of China, has its own financial problems. A lot of the initiatives getting attention in the news are much smaller than they are being hyped, and they're nowhere near enough to capture the US academic system. That could easily change though.
My sense is a lot of people are kind of holding their breath to see how things turn out, but I think it could be really bad. As the article points out, it's probably the junior scientists most at risk of leaving. But those are also probably the people you want to have stay, or attract.
There are a ton of problems in academics that have needed remedy for a long time, but what is happening now is making things much worse. It's certainly not in good faith, and not actually intended to help science in the US — if anything it's maliciously intended.