Rotation is essential to avoid loosing one's digital identity, that's a fundamental part of what Nostr offers.

Yes, delegation in the NIP-26 form doesn't fully solve key rotation because there isn't an immediate way to revoke a key.

For who is speculating what NIP-41 is, read here: https://github.com/pablof7z/nips/blob/nip41/41.md