This appears to sacrifice more horizontal space, I don’t see this coming to desktops in its current incarnation as motherboards are already super cramped and replacing 4 ram slots for one doesn’t seem like a trade off most users are willing to make.
Having four slots on consumer motherboards is already nearly vestigial in the DDR5 era: two slots is already enough to hit 96GB (128GB later this year), and filling all four slots with dual-rank modules comes with severe speed penalties. Buying a single module rather than a kit with a matched pair is an improvement for consumers. The main sacrifice with LPCAMM2 is losing the ability to reach a quad-rank configuration. But the current limit of 64GB with LPCAMM2 for a mainstream processor with a 128-bit memory bus is definitely sufficient for most consumer desktops, including basically any gaming desktop.