How long do you think it will take for paper money to be phased out for good? Will CBDCs be able to replace not only paper money but also credit/debit cards? Your input will be greatly appreciated. Thank you.

CBDCs will not replace fully the paper money. They just can't. And not all governments will issue CBDCs.
It will take more generations until paper money gets phased out, if ever. There are still many people who don't use technology, there are still many regions not covered with internet; those just cannot go without an offline currency.
Paper money is here for good, digital currency will only be a complement to the existing paper money. And to think that not all areas have good internet connection, so digital currency will not very useful as most people will still prefer to use the paper money that they have lived for. And I guess even if the whole world gets fully digital, paper money will always remain as the main currency, and CBDCs will always be an option or a second form of currency.