"Initially envisioned as a backdoor pilot" is adjectival and presumably intended to modify Arrow or The Flash. However, the sentence is badly written, so the phrase instead seems to modify "positive reception", which makes no sense.
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.