MPEG-2 video is still very much alive. In the US, almost all terrestrial OTA broadcast (ATSC 1.0) and all SD channels on cable systems. Even Comcast VOD was all MPEG-2 (including HD) until they shut down the QAM version in 2023.
I don't see H.262 as becoming completely irrelevant any time soon, so it's clearly had a hell of a run, but I expect H.264 to wind up having a similarly long tail. I am not sure I'd bet on it being longer, but I wouldn't bet against it either. I'm only of the opinion that H.264 will have one of the longest of any video codec, but perhaps not the longest.