I saw it, it's actually pretty cool. But I suspect it's a very niche thing, and you might see someone build a third party extension.
Most people agree that a screen should feel like a physical desk where windows can pile, overlap, and scatter naturally. Would you use a tiling "system" for your physical desk? I highly doubt it.
Niri's infinite scrolling approach makes that into a rigid filmstrip sequence. It might be interesting for some people though.
The question is whether most people use a screen like a desk. Nearly everyone I know has a window maximized all the time, and occasionally floats a window to drag or something extremely temporary (e.g. calc). Niri has a significantly lower impedance mismatch with that workflow (and it can temporarily float windows).
Where they could improve is hotkeys: they are all heavily reliant on them, which is unreasonably hostile to non tech users.
Humans aren't very good at identifying what they need from tech. The earliest example is the spreadsheet: no average user would have asked for it because there was no skeomorphism to draw from. We would have had graph paper with a single char per cell if we went with skeomorphic.
Cascading window managers are objectively terrible. Obviously we don't force better solutions onto people, but they have very few redeeming qualities.