Scandal-Hit Prince Andrew Gives Up Duke of York Title Amid Ongoing Controversy