Maquis
Does the worker sent to Officer's Mansion's card stay there for the rest of the game?
No. That worker is available again and returns to a Safe House when it can get home safely, like any other worker. Only missions that explicitly say a worker is lost to complete them keep one out of play.