it is not standard
It is standard, if it is wrapped in P2WSH or P2TR. Only for P2SH or raw scripts it is non-standard.
no wallet has implemented it
Well, Bitcoin Core can handle it. And you don't need the whole chain to sign it, you only need to know, where your coins are, what amounts are in use, and where you want to send your coins. Then, "signrawtransactionwithwallet" can handle it, through descriptors, and you don't have to manually calculate z-value for your transaction.
However, if you're thinking of putting real money into this, I strongly recommend you avoid playing with matches, and just place all M keys into the bunker.
That's why we have testnets, to check things, before deploying them into production. If you can handle test coins correctly, then you should be able to handle mainnet coins as well. Also, if you want to test it on mainnet, then you can always set allowed fees to zero, disconnect, and check, if your transaction will be accepted by your own node. Then, the rest of the network won't see your transaction, but you will get more confidence, that your coins are spendable, if your own node will accept it, and include into produced block template.
Is there a need to actually do that?
Why not? The scripting language was invented to allow custom contracts like that. If everyone would stick with only well-known and standardized scripts, then we wouldn't need Script at all. We could instead allow only well-tested ways of handling coins, and introduce every new use case through yet another soft-fork. But Satoshi decided, that this approach is too limited, and invented Script instead.
I wouldn’t risk my holdings on a new script either.
At the time of writing, someone put
0.18890000 BTC on a P2WSH with OP_CODESEPARATOR, see
bc1qqe0mf9qd47cvsxhpz470456ed6gppax7rx9rdyjdwvynwzettznqsv48l4. I guess there are more Bitcoin Core users than I anticipated, because I don't know any other wallet, which would handle scripts like that correctly.