Consoles are to be a silent entertainment appliance, which cost as little as possible, to reach as wide market as possible. It is a surprisingly powerful hardware for what it is already - they always are. Do NOT expect it to have a powerful RT acceleration etc. anytime soon - that would increase cost, power use and generate noise. All of that means it will simply not sell in a wide market, which is why it will just not happen. At least not till GPUs in prices of up to £200 and with low power use (below 200W) can run RT comfortably (at least with upscaling) - which, again, is not going to happen in the next decade most likely.
Similar situation is with mobile - and mobile is the main gaming market out there, with consoles and PC together being far behind. There is a reason the best selling console with the most games sold on it is still Switch and not XB/PS. Majority of gamers seem to care for the actual gameplay, not graphics (and defo not RT) - which is where the most of modern AAA games on a PC fall short, these days. For most people it is not a hobby, it's just entertainment, which should be accessible and cheap - and that is all they care about. RT simply doesn't match with that, yet.
Also, the Steam stats - 2060 GPU technically support RT. Is it playable in new games? Hell no! Anything below 3080 is pretty much too weak to run RT sensibly well in new games. As HU said in the video, cards below that have to run DLSS already just for raster in many cases, so adding RT on top just kills performance and DLSS doesn't help anymore with that. RT is clearly aimed at hobbyists with deep wallets currently, which is far from being mainstream.
It gets hated because it's way too expensive to get into it and people are being "attacked" by NVIDIA's adverts about it all the time. They can't have it, so instead they hate it - it's just NVIDIA marketing backfiring, as it's aimed at wealthy gamers, not mainstream, so it just annoys mainstream people. That's all there is to it really, IMHO. AMD has exactly same pricing issues but doesn't rub RT into every person's eyes all the time, yet, so gets less flak about it.
It's really not on its way out and won't be for many many years to come. Few AAA games introducing RT for top few % or so of rich gamers doesn't make raster go away anywhere. You're falling for NVIDIA's marketing again.
I'd say 95%+ of games coming out these days are still full raster, with no sign of that changing. Loud releases of AAA games are just a miniscule part of the whole gaiming market. It will happen only when consoles and GPUs can run it well and cheap, with low power use - currently it's simply a gimmick for such hardware. Out of all games I play these days only The Riftbreaker and CP2077 have RT, all the rest either have none or it's a small optional (and largely irrelevant) addon in them. And most of these are new games from 2023. But I like to play games with good gameplay (as in, fun games), not live services abominations or bad stuff like Starfield (which is sadly most AAA games these days - looks over substance).