DFPP is mainly used in the GPGPU applications found in scientific research etc. It is for where calculations that can be made in a parallel fashion also require high precision.
In terms of games, it isn't massively utilised as there is rarely any need to make such precise calculations. Also FP64 instruction set based calculations massively impact performance. As a general rule, games tend to get away with FP32 (single floating point) instruction set calculations.
Double precision is useless for games. It is important in models and simulations where a high degree of precision is important. Basically for stuff like fluid dynamics, modeling the weather or other aspects of a planet, modeling the sun, and other stuff we use super computers for. In these cases, 32-bit single precision is less accurate and thus leads to a less accurate model than double precision.