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.