it adjusts every two weeks on average,as soon as the mining gets unprofitable or marginally profitable
the hashrate drops,blocks are being found less often and the difficulty adjusts so that the blocks finding time is 10 minutes on average
thus leading to lower difficulty and more profit for your PoW stake,hence more people will start mining and adjust the difficulty again
it is a very adaptable system and it has proven to be working
besides even after all the halvings are done and there is no substantial block reward,miners will be profiting from the transaction fees
Basically, it'll still be profitable but that doesn't mean it won't leave the system more vulnerable to 51% attacks. That's why Jihan Wu controls such a large amount of the hashrate (because mining becomes less profitable -> less people mine -> system is vulnerable).