The tweet will remain pinned. Unless, of course, Twitter shuts it down. I'm sure they have a reason for not allowing users to pin others' tweets. It could be to prevent targeted abuse, for instance.