Python does not typically end up in a video game's main code base. However, to say it failed is to have a pretty limited view of game development. Art asset creation often requires customized tools within software packages like Blender or Maya. Python is doing just fine within it's part of the development pipeline.