Tig Notaro was one of the only good parts of some of the modern Star Trek shows. But, she'd be an absolutely awful Bond. It might be fun for a 5 minute sketch comedy parody of Bond, but for a full 90 minute movie it would be terrible.

Her defining trait as a comedian is her deadpan delivery. Bond has a dry sense of humour, but that's very different from a deadpan affect. He's also extremely charming and charismatic, which doesn't work well with a deadpan delivery.