DLSS still needs discrete hardware to do that (and keeps requiring
new hardware on each generation). Not to mention the types of RAM are
not the same and have entirely different tradeoffs - using GDDR for a CPU would
tank performance due to an order of magnitude worse latency, using DDR for a GPU would make games a slideshow due to an order of magnitude worse bandwidth. And you'd have to redesign the entire concept of how CPUs and motherboards work to get there, while making AMD and NVIDIA agree to have their chips be behest to the bridges of shitty motherboard and consumer RAM manufacturers even more than they already are.
Integrated systems have come a long way for highly optimized mobile and laptops designs with specific hardware in mind. But even if everything went perfectly - DLSS 5 on a 5090 halves the frame rate and requires a 5090. And it can only do a single style - gritty, high contrast lighting photorealism.
In 10 years will new GPUs primarily be AIPUs? Sure, probably, but they'll still be discrete and they'll still have significant raster and ray tracing pipelines to provide the basis of rendering.
Then again, maybe AGI will come and hardware will fundamentally revolutionize overnight.