Like everything, it's not impossible even though SP maps were designed with SP gameplay in mind. Especially the Tirailleur warstory. It's super linear and maps are really thin. They were also not built to be "balanced". This mission specifically, the attackers are at a really big disadvantage.

Looking at the map from a Design perspective I don't think Conquest would work but maybe Breakthrough could.

On the other hand. it would take way way more than just a couple of covers.

Also, there are some technical stuffs happening in single player maps compared to MP maps, like streaming of data while you play. A ton of stuff would need to be un-linked with the systems in the back that the players don't see.