To be precise, Bell's inequality rules out a local hidden variable theory. Pilot wave theories/Bohmian mechanics is an attempt to describe a nonlocal hidden variable theory of quantum mechanics.

To be even more precise, it rules out hidden variable theories that satisfy Bell locality, i.e. the assumptions that the theorem makes.

Superdeterminism and retrocausality both allow for local hidden variables - it’s just that they don’t satisfy Bell’s assumptions.