The 32GB one from this article is the consumer product with the same Optane technology as the enterprise/datacenter one. The DC-P4800X (the datacenter one) has 375GB, 750GB, and 1.5TB variants[1].
So, no, if you have 1TB of memory a 32GB Optane SSD isn't going to make a difference, but if you have 1TB of memory, you're not the target for the 32GB consumer version, you're the target for the 375GB+ datacenter version.
> you're the target for the 375GB+ datacenter version
Keeping in mind that that version costs $4/GB, which is about half the price of adding more RAM. Which means that while it can be good storage for ZFS or a database, it's still not a particularly effective cache in such a machine.
It costs $4 per GB today. In 6 months it will probably be $3, and in a few years it will be $2. Meanwhile RAM will still be $8 per GB or more. Also 64GB dimms are around $13 per GB, and have been around that price for awhile.
So, no, if you have 1TB of memory a 32GB Optane SSD isn't going to make a difference, but if you have 1TB of memory, you're not the target for the 32GB consumer version, you're the target for the 375GB+ datacenter version.
[1]: http://www.anandtech.com/show/11209/intel-optane-ssd-dc-p480...