Can there be a day bitcoin moved to the wrong address can be retrieved.
No. Bitcoin was programmed in a way once your transaction is successful it becomes irreversible, if you made mistake with the address then consider it lost and gone, no recovery for this one. Knowing that Bitcoin transaction on the Blockchain expecially transactions done in non custodial wallets needs to be studied before sending, there needs to be several checks, copy directly from the source and I don't know if it happens but anyone who types recipient address should instead copy and paste.
You're right this is the reason why one has to be careful when sending Bitcoin always make sure that the wall address you are sending it to is the actual address and avoid making mistakes because just a change in one of the letters or alphabets on the wall address will alter the address entirely to be a different one so always do a proper background check on the wall address because when once you have sent it it can't be reversed, this is the main reason why alot of person's has gotten scammed of their Bitcoin assets so when sending be extra careful