^ represents the start of the string, see this reference https://www.mysqltutorial.org/mysql-regular-expression-regexp.aspx
To find values that start with a sting you would use “LIKE” “name_%”
LIKE and REGEXP are completely different.
WP_Query does not allow “LIKE” or “REGXP” on meta keys