Of course the drone needs to be on. Try plugging your phone to the pc while it isn't powered on. It will not recognize it as a drive.
The easiest way to get the videos off the micro sd card is to just remove it and insert it into the pc with an adapter.