I believe that, as Indirik said, if both warring parties declare Hatred, it becomes permanent.
There's an impact at the region level. Sympathy for a realm you're at hatred with will drop dramatically in your regions, making it ultimately more difficult for your opponent to hold onto your regions if they conquer them. It can slow them down.
