It is reversible. If you make a mistake like this oftentimes you can rely on law enforcement/bank to force the money to be given back. Not sure if this is possible with crypto.
This is why you hear people losing their life savings to scammers in Nigeria, instead of just successfully suing them to get it back.
I would say more often than not it's reversible.