Cassini will long be remembered as one of the most ambitious and successful space missions ever undertaken as it is finally taken out of service.