Wales must take the long road to Euro 2024 after automatic qualification hopes extinguished