Conversion to number, number is not recognised
Default separator is "." and not ",". That's why it's crashing - it's looking for the ".", not finding it and thus not recognizing the numeric value.
https://docs.snowflake.com/en/sql-reference/functions/to_decimal.html
You could run REPLACE() to replace all "," by "." and then apply the cast.