pull down to refresh

Do new OP codes need to be activated to allow this to work?
No, it can work right now if someone builds it. And Zman wrote that he composed this in part because he thinks bitcoin has ossified and no more soft forks will happen (with caveats for "small" fixes):
We must [scale bitcoin] without any blockchain consensus changes... The Bitcoin blockchain has ossified in practice. Due to the scheduled halvening every 4 years causing a sudden increase in Bitcoin price, leading to a sudden increase in interest in Bitcoin, large batches of new users join the set of entities with an interest in Bitcoin consensus. As the previous batch becomes convinced of some consensus change, the new batch enters Bitcoin, which must itself be convinced of the same consensus change. If a consensus change cannot achieve practical consensus within a time shorter than a halvening period, it will not ever happen... OP_CTV was largely finalized in 2020, and has not achieved consensus in 2024, thus will never achieve consensus due to exceeding the halvening period; SIGHASH_NOINPUT has even worse prognosis... source