pigpio(d) ia again something different. RPi.GPIO in fact does not work on RPi since Bookworm anymore, as the related API is not provided by the kernel anymore. As alternative for python3-rpi.gpio there is python3-rpi-lgpio as shim, providing RPI.GPIO API on top of modern lgpio API.
The pigpio lib generally seems to still work, but does not support RPi 5: CM5 support · Issue #621 · joan2937/pigpio · GitHub
It is the same type of low level RPi-only API that is not featured anymore by RPi engineers.