A trident (with loyalty) thrown from the off-hand does not return to your off-hand.

If your inventory is full, the trident flies around you until a space in your inventory is made.

If there is a space in your inventory/hotbar, the trident returns to the next available slot rather than the off-hand.

A video of this:

https://youtu.be/xJ8QUkFvWk0