Not quite.

It requires special application support, you are 100% unlikely to ever discover an app in the wild that can use it.

According to the SSG website, Autodesk Maya will fully support the SSG, including the 2TB memory.

"ProRender plug-in for Maya has full support for the out-of-core rendering feature found on the Radeon™ Pro SSG which allows the application to tap into the full 2TB of memory found locally on the card. This allows users with very large models to render fully accelerated by the GPU. "

Apparently application support is implemented via the SSG API. It doesn't look like it's a public API; I can't find any documentation anywhere.

The fact that "2TB is addressable" is irrelevant. Putting NAND on the board doesn't improve latency/bandwidth nearly enough to function like vram. Nvidia has also supported unified virtual memory since Pascal, meaning you can address your cpu's ram in GPU code. The "SSG" card still has the 2tb of flash on a PCIe interface, so not much difference from existing systems beyond marketing. I'd expect very few real world perf wins.

Do you know anything new about the Radeon Pro SSG? I haven't read anything since the announcement.