This was obvious, wasn't it? A country with the largest population in the world has introduced CBDC version of its paper currency, it's obvious that they would have the highest number of users of digital currency, also in a country like China where financial inclusivity is quite high, but obviously, you can't compare Bitcoin and Digital version of Yuan in any way, in fact there is a good chance that people using Digital YUAN would still find it difficult to operate private key bitcoin wallets. But I disagree with your statement that Bitcoin has failed to do so, the best thing about bitcoin is that it didn't imposed it's usage, you are free to choose whether you want to use it or not while the same isn't the case with Yuan which was imposed in the country.
If you read the news posted by OP it's, "40 million Chinese punters adopt Digital Yuan and spend up big". Its just like comparing apple with oranges. Governments are encouraging and enforcing use of digital version of fiat over cash for better visibility of financial activities and increasing tax net.
The list of sucess btc achieved in a decade time is far more then what fiat achieved in centuries. Btc has brought complete democracy in financial system which was greatly abused by centralised financial institutions.