There are some great insights in this article. I wish it were not tied to Scrum.

"how many of these insights informed the Scrum framework"

I don't think so. One of the creators of Scrum admitted to a colleague of mine in 2002 that he (the Scrum inventor) "knew nothing" about organizational behavior or change.

Any theoretical framework for Scrum is after-the-fact and accidental.

The author makes some excellent points regarding motivation, but the Sprint goal is not the best model for aligning everyone on a goal. The goal should be about an outcome - not about tasks or stories and certainly not time boxed.

If you look at highly agile companies like SpaceX, they don't use time boxes. They have goals in mind, but people work at different rates, trying to achieve something, and they are continuously reflecting on it.

The idea that everyone on a team has the same goal is nonsensical. People have different immediate goals; and there is an ovrerriding outcome goal that cannot be time-boxed.