CBDCs highlight all the shitty aspects of fiat currencies. Why would the public willingly adopt this technology when they have a 1,000,000x better alternative?

There is no reason. They will choose #Bitcoin .