The European Super League is dead on arrival but the impact of the aborted project will still leave a mark on those involved