The Duke of York faces a bill of millions of pounds after settling a sexual assault case with his accuser, Virginia Giuffre. This, in effect, ends his career in public life, says royal reporter Caroline Davies