2024 Bell Riots were the tipping point[0], but there was still World War 3 a few decades later. A global nuclear exchange probably helped a lot in kicking human civilization off the dystopian but locally optimal path it found itself stuck on[1]. Meeting a technologically superior alien race a decade later also helped solidify a different perspective :).
But yeah, I too was disappointed when 2024 came and gone without the Bell Riots - Star Trek came this close to accidentally turning prophetic, as in the months prior things really felt like the Riots are going to happen on the date.
--
[0] - In that timeline, at least. We've already past several important world events that originally happened in Trek timeline, so the show keeps shifting the dates to keep with the overall premise of being imagined future of real humanity.
IIRC the writers now settled on "Romulan temporal agents meddling with timeline, desperate to stop the Federation from forming, and failing because apparently the cosmos really wants UFP to be a thing" as a convenient explanation to push WW3, Eugenics Wars, etc. forward every once in a while.
[1] - How humanity bounced back from that so quickly is something of a mystery to me.