Is pinot noir a dry or sweet wine?

Generally, no. Any wine can be made sweet, it is a function of how long you ferment the grapes.

(less fermentation would leave some fruit sugars behind)

Pinot Auxerrois is closely related to Pinot Blanc, another that is usually not used for sweet wines.