SNOW-1347796: Fix incorrect regex used in Series.str.contains #6090

Job	Run time
Check linting	57s
Type Checking	31s
Build Doc	1m 34s
Build Wheel File	9s
Test Local Testing Module py-macos-3.8	3m 40s
Test py-macos-latest-3.9-aws	9m 6s
Test Local Testing Module py-macos-3.9	3m 2s
Test Enable CTE Optimization py-ubuntu-latest-64-cores-3.9-aws	7m 35s
Test modin extra without pandas extra py-macos-3.9-aws.	1m 41s
Test py-windows-latest-64-cores-3.11-gcp	12m 9s
Test Local Testing Module py-macos-3.10	3m 21s
Test py-ubuntu-latest-64-cores-3.9-aws	8m 18s
Test Local Testing Module py-macos-3.11	2m 50s
Test py-ubuntu-latest-64-cores-3.10-azure	6m 37s
Test modin-macos-latest-3.9-aws	8m 35s
Test modin-windows-latest-64-cores-3.11-gcp	29m 36s
Test modin-ubuntu-latest-64-cores-3.9-aws	32m 31s
Test modin-ubuntu-latest-64-cores-3.10-azure	22m 45s
Combine coverage	1m 23s
	2h 36m 20s

Provide feedback