Nope; banks can and will reverse transfers, and if the money was transferred fraudulently, THEY will take the blame for it (because in essence their security failed, even if you are the one that initiated the transfer). Banks have a fund to compensate victims, and banks are connected to national and international banks and regulatory bodies (like the ECB) to get you out of shit creek if there is a problem.
Banks are not perfect, but at least they pay up if you run into one of those imperfections. Usually.
Banks (especially banks in the same country) can send funds back, that's not the same thing as reversing the transfer. Both SEPA and SWIFT transfers are irreversible. It's even possible to steal money from a central bank by transferring money away with SWIFT.
The only real difference is that it's not legal to keep mistakenly sent funds, making irreversible mistakes less likely to happen.
Banks are not perfect, but at least they pay up if you run into one of those imperfections. Usually.