Government doesn't care what people want. Those in government want control and nothing will give them more control than a CBDC, so it will be pushed hard.
Unfortunately, as much as most people don't want it, if the government starts giving out entitlements and other handouts (what people consider "free" money), most people will jump in with arms open wide in order to get their money. Once people are used to using the CBDC, they will remove the ability to use other currencies including the plain USD. It will be too late to do anything about it at that time. I do think precious metals and bitcoin will help and be a workaround at least for a while. It is hard to know longterm.