It wouldn't work on my computer with pen USB drive. Not even with USB harddisk, nor with CD, nor with DVD. Turning off autorun is on my list of things to do after installing Windows on a computer, right there with "get antivirus" and "install Windows updates". I suspect lots of people do the same.
However, there is no fundamental difference between USB pen drive and any other USB storage device. If the autorun is enabled and the USB pen drive is properly furnished for autorun, it should be run when plugged in.