Tensions in $e^+e^-\to\pi^+\pi^-(\gamma)$ measurements: the new landscape of data-driven hadronic vacuum polarization predictions for the muon $g-2$