RE4 gave the PS5 a nice boost. I am not being sarcastic.
It should be clear to everyone that these 90k weeks we've seen before weren't just for gamers in Japan, and combined with Sony's shipment target of 6.2m worldwide for the current quarter, it was only a matter of time until stock was more evenly distributed across all countries, making it less necessary to import from Japan. Pretty soon we should arrive at the point where the PS5 sells according to its actual demand in Japan.
The PS4's baseline during its best times was 25-30k when it saw a continued stream of new game releases, so it stands to reason that the PS5 will have a hard time to settle above that. In the most recent weeks we've seen drops from 90k to 75k to 65k to 40k and now it managed to hold on to 40k for a second week. RE4 can be given credit for this.
Lastly, we are approaching Japan's worst month of sales: May. Before that, there's Golden Week in April, but what used to be a notable boost for all hardware barely moves the needle nowadays. The point is, there's no need to worry too much about lower sales in the upcoming weeks, because low sales are pretty normal for that time of the year.