The sad thing is that, from what I can tell, Intel doesn't have a true planned successor to Alder Lake-N.

It really might be as bad a mistake as not having Intel Isreal's futher development of Pentium 3 would have been. (in other words, no Pentium M, no Core 2 Duo, no Nehalem...)