It looks like you're new here. If you want to get involved, click one of these buttons!
The concept art never gets included into the game itself unless it's at loading screens. And the game itself pretty much never looks anything like the concept art.
Is concept art mainly a marketing thing, as it does sometimes show up in ads for the game? Is it mainly done so that games can have nice looking loading screens that nearly everyone will want to skip as quickly as possible?