Really? In Northern Ireland in the 80s/90s it was always used in the same way as spaz / flid etc - ie. an ableist slur. Kids would typically scream it when someone did something clumsy or uncoordinated. Lovely, eh?

I don't think I've actually heard the sex thing being used anywhere in the UK, except perhaps when discussing Pulp Fiction. Even in kink contexts!