Typically used in banter, a soggy pigeon is a person who doesn't deserve your time, but you won't say it to their face because your afraid of socialising.
"Oh my god, will you ever feck off, soggy pigeon."