The figurative sense dominates daily use:
上贼船 ("to board a pirate ship") = to get sucked into a shady operation, dud business, or doomed project from which it's hard to escape. Companion phrase:
上贼船容易下贼船难 ("easy to board the pirate ship, hard to leave").