Lets be honest the pilot was awful, trademark Guggenheim rubbish. Beth getting the showrunner gig instead of him showed it had real potential with a competent showrunner at the helm should it have been ordered to season but the backdoor pilot failed to get any traction with the shrinking fanbase never mind the masses and it was leaning heavy on CW filler to appeal vs DC with non canon daughter of Oliver Queen in a romantic relationship with the son of a CW creation in John Diggle who would also be the main villain (which is hardly compelling antagonist to launch a show with).

I think if it leaned more on DC and less on CW made up stuff it might have had a better draw than it had. Instead they were going more with what Legends ended up being... all CW fan fiction which did not resonate so well and shrunk the fanbase (Legends ended up with an entirely CW lineup with no DC characters remaining and tried to hail mary tease Booster Gold just to get a renewal).

Perhaps this was no fault of CW in the end up, perhaps DC were playing funny buggers with access to their characters by that point as they had done so in the past with everyone from Suicide Squad to Deathstroke being denied to CW and John Constantine had to be written out because of DC as well. Gotham Knights was decidedly Z lister as you can get whilst DC of course kept the likes of Nightwing and Red Hood for their own show Titans on HBO Max. Orrrrr CW was fully at fault for using up and in some cases wasting just about every Green Arrow villain there was to feature in a show after so many seasons of the arrowverse... with all the heavy hitters featured already or utterly wasted (seriously what they did with Shado who should have been main villain material hand down say its all and Komodo was a villain of the week that practically no one will ever remember... really CW?). The fact the Arrow flash forwards were never well received in the first place meant it was always gonna be a hard sell as a concept.