Many bottoms lose their erection while being fucked, especially if they're experiencing the edge of pleasure/pain. Often times it can also be sensation overload/overstimulation that can cause the erection to fade. It doesn't mean they're not enjoying the sensation, just that the body can only process a certain amount of sensory information at once and if attention is diverted from the dick to the hole, the dick may or may not maintain its responsiveness.