After doing it for years on ‘Saturday Night Live’—in sketches that were often too weird (read: too cool) to air—the former cast member is bringing his particular brand of comedy to the big screen