For context, I worked as an enterprise systems admin for many years. I still keep my eye on the server and network sides because I am an enterprise application admin now, and the app I manage uses a huge amount of storage (log aggregation and search) and system and network performance. I am also a hobby computer builder.
I think this article from Serve the Home gives a lot more information about newer enterprise drive form factors. The comments are particularly illuminating:
https://www.servethehome.com/e1-and-e3-edsff-to-take-over-from-m-2-and-2-5-in-ssds-kioxia/ Based on the article and the comments, this seems another situation with competing standards, so as to tie enterprise purchasers into a single vendor platform.
First and foremost, the photo in your link is incorrect. If you search for "Dell 85HT8 SSD" and look at pictures of the actual item such as at harddiskdirect.com, you'll see the actual formfactor of these drives.
You would need to purchase a server that can accommodate these drives, as they are not going to work with current gen consumer motherboards. Servers are notoriously noisy, in many cases loud enough to cause hearing damage after extended exposure, so you'd also need a way to mitigate that.
These are also TLC NAND which has lower endurance, so purchasing used drives is a bit of a crapshoot, IMO, and not really "future proofing" given their price and the additional cost of a server.
A number of popular gaming motherboards support PCIE slot bifurcation, allowing you to use PCIE carrier boards to add as many as 4 additional NVME drives in one PCIE slot, making this specialized enterprise storage irrelevant for home use, IMO. When higher capacity NVME drives come down in price, this will be the direction I go to upgrade my home fileserver.