Long Term is the 12 word seed going to really always protect your funds? is a 24 word seed secure with the rate of AI and Quantum advancements? Even with a passcode and a pin. And then what about a physical attack?
A 12 word seed phrase gives you 128 bits of entropy. Bitcoin private keys give you 128 bits of security. If 12 words isn't safe, then the entirety of bitcoin isn't safe. So yes, 12 words are fine.
The 4 digit PIN on your bank card gives ~13 bits of entropy. The 15-60 digit bank card itself gives ~50 bits of entropy. The password on the vast majority of online accounts gives less than 80 bits of entropy. 128 bits are more than enough.
And quantum computing does not provide any meaningful speed up when it comes to raw brute forcing of seed phrases. Quantum computing poses a risk to the ECDLP (i.e. calculating a private key from a known public key), which is why at some point bitcoin will likely fork to a quantum resistant algorithm.
The problem with the 24 words is that it adds a new complexity, as it increases the possibility of forgetting several words or changing their order
You shouldn't be remembering your seed phrase at all. Write it down.
Then the most secured method at the moment is setting up a multi sig wallet with an each co-signer having its own device. This multi sig will help to protect funds from been stolen when one of the seed phrases or keys becomes either physically stolen or even through phishing attacks or hack.
Note that a multi-sig only provides additional security when it comes to your back ups - it does not generate addresses which are more secure than 128 bits. In fact, if you use old style P2SH multi-sig instead of P2WSH segwit multi-sig, then you actually create weaker (but still entirely safe) addresses.
No matter what measure you take, the private key in Bitcoin will offer 128 bits of security.
I would slightly modify that to say a private key will offer a
maximum of 128 bits of security. There are plenty of ways to generate private keys with much less security.