I would generally be against this change. Others have noted that the change effectively prevents anyone from ever accepting a 0-confirmation transaction, which I think is a net negative for the bitcoin economy. I think this change will also make accepting 1-confirmation transactions (and to an extent, n-confirmation transactions) riskier. If a customer were to receive something of value after one confirmation, if the block that included the transaction is orphaned, and the new block does not include said transaction, the transaction is again unconfirmed and can be trivially double spent.
While i don't know any statistic about orphan block, there statistic about stale block. Based on BitMex monitoring tool[1], there are only 46 detected stale block since 20-08-2020[2]. It's quite rare, so IMO the risk is rather low. Besides, this risk could be partially mitigated by requiring more confirmation for high-value transaction.
[1]
https://forkmonitor.info/notifications[2]
https://forkmonitor.info/feeds/stale_candidates/btc.rss