Andrew, 61, reportedly “expected” the decision but believed he may have time to “clear his name before his titles were removed”.
His titles were removed from him by order of his mother, Queen Elizabeth II ahead of his looming civil sex case trial in the US.
Prince Andrew has been accused of sexual abuse by Virginia Giuffre, which he has denied, in the civil lawsuit.
Following the news that the trial will go ahead, the Duke of York handed back all 12 of his military affiliations, including Colonel of the Grenadier Guards.
A senior defence source told The Mirror: “The Prince was tearful when told the news even though he had expected it. He feels that he has let so many people down, not least his mother, during her Platinum Jubilee year.”
An insider told the publication: “He had hoped that he might get some sort of stay of execution and be allowed to clear his name before his titles were removed.
“There are a number of people in the royal household who are utterly convinced that he is innocent.
“But the clamour for Andrew’s scalp meant that a quick and brutal decision needed to be made.”
But, a source close to the Duke told OK!: “He’s quite sanguine about it. He was mindful of the intense pressures building on the institution and recognised it was the right thing to do.”
Following news of the trial’s confirmation, Buckingham Palace released a statement on Thursday, 13 January.
It read: “With the Queen’s approval and agreement, The Duke of York’s military affiliations and royal patronages have been returned to the Queen.”
“He will continue not to undertake any public duties and is defending this case as a private citizen”, the statement concluded.
The senior defence source told The Mirror: “Andrew is a victim of very poor decision-making. There is no way he could continue as the honorary head of distinguished military regiments.
“His departure has been greeted with a huge sigh of relief. He had become a b***dy embarrassment.
Get exclusive celebrity stories and fabulous photoshoots straight to your inbox with OK!’s daily newsletter. You can sign up at the top of the page.
“He could not be present at parades, visit units or welcome troops home from operations because the story would always be about sex scandals and not about the regiments.”
The defence source continued: “The big question now is who is going to fill these roles.
Become an OK! VIP and you will unlock access to all of our big exclusives…
Be the first to meet the latest showbiz babies, see the most sought after wedding pictures of the year, or take a guided tour around your favourite star’s lavish multi-million pound home – all for free!
“Honorary titles are hugely important. The role of Captain General of the Royal Marines was held by Prince Philip for 64 years. He knew the Royal Marines intimately.”
A source told the publication: “He fully maintains his innocence, but wants to apologise for the difficulties caused by what has happened.”
For more showbiz updates, sign up for OK! ‘s daily newsletter here.