If motor turns but it doesn't retract or extend, it sounds like the gears are stripped or out of alignment. Not working with the drill makes sense in this case also.
Can you twist it by hand and then zip tie it shut? It may take 2 people working together to roll it up manually. If you can slip a zip tie or two behind the vertical supports once you get it rolled up, they should hold it shut.
Robert & Diana McNeal
2019 Montana Legacy 3791RD 20th Anniversary Edition
2014 F350 4x4 6.7L SRW