Issue relies here : regexp_extract_all will return a list, use regexp_extract instead

regexp_extract_all :

Finds non-overlapping occurrences of regex in string and returns the corresponding values of group.

regexp_extract :

If string contains the regexp pattern, returns the capturing group specified by optional parameter group