The memory is slower but not by much, 256 GB/s is much faster than system memory found in most consumer-targeted PCs. The devices have way more memory, up to 128 GB. A system with a Strix Halo APU is a general-purpose computer; these special accelerator cards can only be used for one thing.
I have a 4090, and given the MoE trend, I'd be more tempted to purchase a Strix Halo next than a 5090.
And that means I have no idea what these cards could be useful for. They are more expensive, have roughly the same VRAM, but are much slower.