Once widely reputed to be Queen Elizabeth’s favourite son and feted as a dashing young military officer, Andrew will now be etched into the public memory as the royal who was accu…