I had this happen a few years ago and did get the miles back.
It took a couple of phone calls and an Aeroplan supervisor to reluctantly agree to reverse the transfer.
I don't recall how long it took to get the miles back but I don't recall it being more than a couple of days.