Fed Funds rates most directly impact the short end of the yield curve (0-2 years), not the long. Long end (5-10 years) is PARTLY influenced by FFR, but more by economic outlook.
Not so say another Fed rate increase or two won't affect 5 year CDs, but it's more likely IMHO that we've seen the peak in 5 year yields with possible rare exceptions - like Bank of Pajakistan or something.
What matters to banks and credit unions is where the rates will be over the entire time they have to pay interest. Sure, the Fed may keep rates high for "a while" (read: less than a year) but it's far more likely they will start cutting by this time next year or mid 2024 at latest. So, if you're a bank or CU issuing a 5 year CD/Certificate, would YOU pay 5% knowing this?
4.75 on a 5-year CD is a good rate. There aren't many out there at that yield, and I don't think the next Fed meeting or two is likely to change that, even if they raise another 50 bps between the two.
All JMHO & YMMV..