Ashraf ʿAli Thanawi states that the Prophets remain alive in their graves and counts this among the beliefs on which Sunni scholars agree.
Affirming the life does not require equating every aspect of it with physical worldly living. The central belief is that Allah grants the Prophets a particular life after death.