Does it mean that the SO is almost dead? It is subjective.
To me, while I dislike categoric statements in subjective cases, the case is surely not far from what the facts say.
Does it mean that everything is over?
Might, but not for sure. On the behavior of the company is it also visible, they still fight. It is only the public platform, they also have private SE sites as a company service (among them customers like Microsoft, as far I know it), they have intellectual property, they have brand, they have databases.
Beside that, AI is now in its exponentially growing phase, just like SO was between 2008 and 2014, until the current, wonderful "curators" did take over the control. Some years, and hopefully AI won't be in exponential phase any more. Also its limitations are becoming more and more clear, I simply hate if I ask a code from it and I get a code what does almost what I wanted. I hate if the AI simply does not know the answer and then answers a bullshit, and I can not flag it for NAA.
Many thinks, they will grow until the infinite, and then it takes over the humanity / solar system / universe. I think, it will be some different, of course it does not mean, that a world ruled by a "better AI", would unavoidably contain also humans, too. Currently, AI does not exactly, what I want. It can create sample code what I can not copy-paste into my work, I must understand it and alter it.
Beside that, as the value of being a "king" here, decreased, very likely also the vehemency of the "curation" decreased. It is visible already now on the MSO.
SO, as we knew it until about 2022-2024, yes that is over. SO as an existing entity, surely not.
What will grow on the ruins, no one knows yet. We are still in decreasing tendency, but the company is investing. What we should wait for, if therein my opinion: I believe that we will soon reach a point happen as in 3 consecutive month we don't decrease in the, where countthe count of the well-receied questions does not decrease for 3 consecutive months. That will be the pointa new balance, as something new starts. No one knows yet, what will be it.