Drastically slower query performance between CentOS (2sec) and Rocky (48sec)

set session optimizer_switch='split_materialized=on';

use b_test;

select this_.`RMD_CURRENT_STATUS_VALUE` as y0_, count(*) as y1_

from `TEST_MAU_REQUEST_RECORD_VIEW` this_

where (lower(this_.`UAR_ALL_EMAILS`) like '%AbeFrazer8@example.com%' escape '!'

or lower(this_.`UAR_APPROVER_STLS`) like '%AbeFrazer8@example.com%' escape '!'

or lower(this_.`REQUEST_BY`) like '%AbeFrazer8@example.com%' escape '!')

group by this_.`RMD_CURRENT_STATUS_VALUE`

order by y0_ asc

limit 50;