In South Africa, where I am at, they've already started to build the infrastructure, but it's being used to settle interbank transfers between the reserve bank and prime brokers, but I doubt we'll see it pushed on the public, its too chaotic of a change.
You need to have a certain level of cashlessness already, if not your CBDC cannot be programmatic, for example, here if you tried to put a CBDC in play and said you have a time to spend it or it has a certain interest rate, it just makes cash a better option and breaks the fungibility of the unit of account, people will trade CBDC's at a discount to cash
As for more advanced economies, sadly I don't see people getting trigged by them, yes there will be a niche at shout about it, but if it works when I go to the store, most people won't think as far as that and governments need that in the beginning, they need you to get entrenched in the system first that you have no outside value then they can sucker into their real policies
So the way I see it is if it does come out they will play very nice in the beginning, many will fall for the psyop for sure