Docs do show that it uses E8d as you wrote.

SQL Warehouses are a different type of compute than All Purpose or Jobs clusters. The SQL warehouses always use Photon. All purpose and Jobs clusters are used for things such as notebooks or Delta Live Tables and that's the 0.75DBU pricing you're seeing.

The azure pricing calculator here has our logo from 3 years ago on it, so I wouldn't put much faith in it.