Red Dead Redemption on PlayStation 3 does not use Sixaxis motion controls.
If you want motion-aim in RDR: Use Steam Input (PC) with Gyro-to-Stick mapping (requires Steam Deck / DualSense / Switch Pro / Gyro-enabled controller). Not possible on native PS3.