There is no scenario where this is “career suicide.” As others have pointed out, it’s a no lose situation. If things work out, he’s the genius who saved a sinking ship. If they don’t, the narrative will be “he could only do so much with what he had to work with.”
Most people taking on new assignments prefer to take over an under-performing business or department as opposed to a thriving one and this is no different.