The co-creation of music superstar Abel Tesfaye, aka The Weeknd, and Euphoria creator Sam Levinson, the series seemed to have everything going for it. So what went so wrong, asks Laura Martin.