Large-scale simulations of phisical systems tend to have a variety of length/time scales that require vast numbers of CPUs to model in a timely fashion. This could be anywhere from a few hundred cpus to tens of thousands. Fluid dynamics, solid mechanics, fluid-structure interactions, electrohydrodynamics, etc. simulation tools can all benefit from having a larger number of highly interconnected CPUs, we can simply resolve engineering problems better with more computational resources for better understanding of problems.
It is not a single language. c, C++, Fortran are the most commonly used. The communication happens using one of many versions of the message passing interface [0] (MPI). MPI essentially spawns child processes and a communication ring between nodes using whichever interconnect is available (usually infoniband).