After years of costly military intervention beginning in 2015, Saudi Arabia increasingly sought to stabilise its southern border. All that is unravelling fast now