Many insist the prince will bounce back but others claim the plight of being a spare to the throne can become a lifelong curse