A BBC presenter was sacked from his radio show after sparking fury with a segment that was called "deeply inappropriate"