Why ADD COLUMN NOT NULL fails on a full table, and the migration that does not

The most searched migration error in Postgres, what actually happens inside the server when it runs, what changed in Postgres 11, and the three-step v