I don`t see how Z97 availability (launched at 2014, 8 years ago) comper to the x570 availability- a 3 years old (lunched 2019)..?
if anything, Intel's strategy of changing socket every 2 gen makes a larger second hand market because mobo is replaced more often.
You are right and I very much agree about Intel's very much one-sided,intensely and profit oriented way of terminating socket compatibility. But that`s on itself, imo, not a reason not to choose them, unless you know you will need to upgrade CPU every 2 years without changing mobo and to be left out with any new features that shows up).
Also, I advise not to too much counting on the ability to drop a new CPU to a 2-4 years old mobo. AMD is not your friend and can, in a flip sec, to not support for some weird reason. You cannot know if the CPU in 2-4 yers time will be of any good for you (thermally, financial, performance wise ect). So my device- choose the platform that`s suite you now, not the one that you hope will suite you in 2-4 years from now.
Other than that, the ability to keep using the same mobo is a wonderful thing for th consumer and I hope Intel will fallow (ye, right..). It is also Important from the environment point of view to lower e-waste even in a small amount (cus you still buy a new CPU).