My honest guess is this will happen probably mid to late summer where people will be able to buy one in-store although I think I'm being a bit too optimistic. Biggest problem right now is all the ordering is done online due to Covid. And because of that, you're basically having to compete with bots/scalpers which is making it very difficult. On top of that there's a chip shortage supply issue that AMD is having to keep up with the demand for both Sony and Microsoft.
Sony is anticipating to sell 1-2 million consoles each month this year but that is globally and they haven't even started selling in China yet until next quarter and they've barely tried selling much in India.
There's been quite a few great drops this past month though and we're starting to see scalper prices go down whether it be on eBay, StockX, FB Marketplace etc. Best Buy has had drops on Fridays the past 4 weeks. Target had a drop of 40k last week. Walmart had a 2 hour drop that was in waves a couple weeks ago. Playstation Direct will have 3 drops a week. Currently right now everyone who is following restock news is expecting Amazon to have a huge drop this week(rumored to be Wednesday or Thursday). Supposed to have 46k PS5s drop. That site will crash.
Good luck to you if you're trying to get one soon!