I honestly wonder if there's actually any need for more than 16-24GB. Sure, the 7th gen was starving for RAM, but those were stuck at 512MB which was as much as a single high-end graphics card at the time.
Is there any PC game demanding more than 16GB RAM nowadays?
Right now, console makers will have to make do with the ongoing market conditions, and that means saving up on RAM costs.
For example, 8GB HBM + 16GB DDR4 at 128bit. Or even 8GB HBM + 12GB LPDDR4X at 96bit.
To the point of release window games only using 3GB (1GB OS + 3GB game IIRC).
I think Killzone Shadow Fall specifically ran on 4GB, among others, for the reasons mentioned above. I probably won't be able to find the presentation where that was mentioned, though.