Logitech G29 Force feedback feels very weak + rotation lock not working

May seem obvious but have you tried the following

https://support.logi.com/hc/en-gb/articles/15412862415895-Troubleshooting-G29-for-power-connection-Issues-PlayStation

also the connection of other controllers may impact your experience.Please ensure you have read the pinned message about console rest or snooze modes.

I would advise testing the wheel on a PC. There are some constructive / confirmatory comments on this thread.

https://www.reddit.com/r/logitech/comments/mek9w4/logitech_g29_not_working_with_ps5/

HTH