I think this is a good idea, as a matter of fact. I am all forward into solutions that automate some kind of repetitive tasks, but not with some drawbacks and probability of failure. This should not be a "macro recording feature" but just a way to chain jumps and save some manual effort. Scooping, honking and other specific tasks would be only be done by the player, and the autopilot route should be carefully planned in order to prevent the ship being stranded for no fuel after the final jump in sequence.
"Winning" in Elite Dangerous is subjective to each and everyone.
No, the auto-pilot would carry on or abort after the ship is fired upon. This ship would be vulnerable in this mode.
And no for the second question. While you picture someone watching the screen after the autopilot is engaged, I find this an excellent feature for breaks or playing while working. During the Distant World's Expedition, I can't tell how many times I was multi tasking, doing simple work tasks while jumping and honking.
For long distance explorers, this would be a great feature to save personal time and even to prevent muscular injuries due to prolonged time doing something as repetitive in the same posture (yes, it happened to me and was a direct result of DWE and my lack of physical fitness by then).
Heck, I would even prefer this solution to the insta-transfer of ships between stations. The downside is that it lowers the hardcore value of reaching the other side of the galaxy by yourself... but not by much, in my opinion.
100% agree, it will only make the game better not easier.