Destiny 2, with the release of the latest season, confirmed some news related to the rewards and the loot not dropping properly when players complete Riven Layer and Coil Season Activities.
Bungie’s Official Notice to Rewards Not Dropping
So, Bungie officially gave a notice related to the Rewards issue in Season 23 with Riven Layer and Coil Season Activity.
Also, they mentioned that there is a fix ongoing for the issue here. Even Luckyy 10P on YouTube discussed this issue, trying out for himself whether the reward drops are consistent in the Seasonal Activities or not.
Is there a Fix for Destiny 2 Season 23 Rewards Not Dropping Consistently?
At the moment there is no fix for that because the issue isn’t related to the front-end of the game, or the system itself. It is related to the servers and Bungie itself has recognized the issue and working on a fix as well.
So, the best we can do is wait and let the developers of Destiny 2 come up with a new patch that fixes the Destiny 2 Rewards Not Dropping Consistently in Riven Layer and Coil Seasonal Activity.