An extraordinary restoration has swept away the lead dust and made the cathedral vivid, but thankfully not kitsch. Our architecture critic takes a look inside