Yes she does a wonderful job
Let's not forget not only did Diana & Fergie make a couple of ...
faux pas 
& get slaughtered by the press so did Sophie.
But thru her dedication & loyalty to Her Maj she is now very well thought of by not only the 'public' but also by the Queen herself.
That is all down to Sophie, nobody forced her to put in all the effort to work at earning that respect.
Frolics in the sun, a bride betrayed, and the end of a honeymoon with the press
WHEN HER camera shutter clicked on a boisterous sunny afternoon almost 11 years ago, Kara Noble could not have known that she was setting the fuse on a time bomb.
The "innocent" shot of an unknown PR girl frolicking with her exuberant boss in the back of a car finally exploded yesterday. The backlash to The Sun's publication of the topless photograph of Sophie Rhys-Jones a matter of weeks before her royal wedding was unprecedented in both its speed and ferocity.
The Independent
Sophie's choice words fuel Royal row
In the latest humiliation to strike the House of Windsor, the wife of Prince Edward has stepped aside as head of her public relations firm after admitting she made a series of unguarded remarks about members of the Royal Family and British politicians that ended up in print.
Globe & Mail
Queen outraged by Sophie comments
The Countess of Wessex has deeply upset the Queen after making a series of outrageous remarks about senior politicians and members of the Royal Family, The Mail on Sunday reveals today...
Senior courtiers said it was 'impossible to exaggerate' the scale of Sophie's blunder. Some openly questioned the very future of the 36-year-old Countess as a member of the Royal Family.
DailyMail
Sophie, Countess of Wessex