Why does the export ask about number format?

Because European Excel and most analysis tools want opposite things. A German Excel expects a decimal comma and will treat a full stop as a thousands separator; a BI tool or a Python script wants a plain decimal point.

So the CSV export offers both, and the choice is yours per download rather than a setting somebody made once. Excel exports are unaffected by it, since the format is carried inside the file.