It's nowhere near 40mpg. The diesel only shows 3mpg more than the gasoline version. Who will pay more $$ for a diesel, thousands more, then pay more $$ for diesel fuel. All for 3mpg? Not going to happen.
Mazda will have to take a loss on US diesel release and maybe offer the diesel for the same price as for the 2.5T gas version.
Car & Driver said it best:
Mazda has yet to confirm when Americans might actually buy a CX-5 diesel*seriously, we've been sweet-talked into thinking this could happen for eight years and now, we are wondering if any Americans will. The Environmental Protection Agency published its estimates for a 2018 CX-5 diesel at 28 mpg city and 31 mpg highway for the front-wheel drive version and 27/30 mpg with all-wheel drive. Compared to the gasoline version, city mileage improves by just 3 mpg for both diesels. Highway mileage, normally the reason anyone buys a diesel, improves not at all.
Making matters worse is that the CX-5 diesel's direct competitor, the Chevrolet Equinox diesel, matches or betters the CX-5 in the city and trounces it on the highway, at either 39 mpg (front-wheel drive) or 38 mpg.
The UK diesel gets 42 MPG, so there*s some confusion as to why the US testing had such terrible results. I certainly wouldn*t take the early numbers as gospel.
That being said, I 100% agree the sentiment in this thread that diesel would flop in the US.