Does my cookie choice apply forever?

No. Your browser can delete cookies, for example, after a certain period of time or when you clear your browser data.

After that, the website may ask for your consent again.