Lots of ideas for key rotation were proposed in the past, but no actual cryptographic reviews or implementations. Much less consensus. It's by far the weakest point of nostr and it really needs man/hours to get through.