After defeating greed and progressing it seems like mind corruption progress completely stopped. Killed sloth and did a couple more side quests and still no changes, what should i do to progress Aura's mind corruption?
The Earth corruption is mostly disconnected from Roya, in fact it's not directly tied to any Roya story progress. If you really have no mental changes available, you may be missing one of the few stat requirements. E.g. you may need 30 Lewdness to progress the relationship with George (and the Earth storyline).
Generally, if 4 days pass without a new scene on Earth, one of the following is responsible:
There is at least one mental change which you have to make (the reusable stat-changing machines don't count).
You've run into a hidden stat requirement. And that one for 30 Lewdness is the only one I'm aware of (and in hindsight I'm not sure it's hidden, you may need it for one of the Hedonism orbs).