Huge exhibition will delve into the emotional vulnerability and sexual depravity of the renowned artist