Do not collect the histogram sum for UpDownCounter or ObservableGauge instruments

[MrAlias]

From the specification:

Histogram Aggregations

...

• Arithmetic sum of Measurement values in population. This SHOULD NOT be collected when used with
  instruments that record negative measurements (e.g. UpDownCounter or ObservableGauge).

Proposal

Update our instrument aggregation selection code to introspect the instrument kind:

opentelemetry-go/sdk/metric/pipeline.go

Lines 423 to 428 in b907996

	case aggregation.ExplicitBucketHistogram:
	switch temporality {
	case metricdata.CumulativeTemporality:
	return internal.NewCumulativeHistogram[N](a), nil
	case metricdata.DeltaTemporality:
	return internal.NewDeltaHistogram[N](a), nil

[MrAlias]

This becomes much easier to address after #4304

Specifically because InstrumentKind is passed to aggregateFunc:

opentelemetry-go/sdk/metric/pipeline.go

Lines 390 to 421 in 7f72e72

	// aggregateFunc returns new aggregate functions matching agg, kind, and
	// monotonic. If the agg is unknown or temporality is invalid, an error is
	// returned.
	func (i *inserter[N]) aggregateFunc(b aggregate.Builder[N], agg aggregation.Aggregation, kind InstrumentKind) (in aggregate.Input[N], out aggregate.Output, err error) {
	switch a := agg.(type) {
	case aggregation.Default:
	return i.aggregateFunc(b, DefaultAggregationSelector(kind), kind)
	case aggregation.Drop:
	// Return nil in and out to signify the drop aggregator.
	case aggregation.LastValue:
	in, out = b.LastValue()
	case aggregation.Sum:
	switch kind {
	case InstrumentKindObservableCounter:
	in, out = b.PrecomputedSum(true)
	case InstrumentKindObservableUpDownCounter:
	in, out = b.PrecomputedSum(false)
	case InstrumentKindCounter, InstrumentKindHistogram:
	in, out = b.Sum(true)
	default:
	// InstrumentKindUpDownCounter, InstrumentKindObservableGauge, and
	// instrumentKindUndefined or other invalid instrument kinds.
	in, out = b.Sum(false)
	}
	case aggregation.ExplicitBucketHistogram:
	in, out = b.ExplicitBucketHistogram(a)
	default:
	err = errUnknownAggregation
	}
	return in, out, err
	}

[MrAlias]

Currently the SDK does not allow for the explicit histogram aggregation to be used for up-down counters or gauges. Given the specification explicitly calls out the exception, it seems like this should instead be allowed. With the correct dropping of the sum when done.