What is a "maximum standard weight"?
It is a property that nodes follow to prevent processing large transactions with number of rules and signatures. It is standardness not consensus. If a node receives a transaction greater than 400,000 WU, it will discard the transaction and not relay it further. I can however, definitely create a transaction greater than 400,000 WU and contact a miner to mine it in a block. The nodes then will be forced to accept that transaction in the block as it is allowed by the consensus rules. So standardness is a subset of validity that nodes use to prevent large processing and DoS attacks.
Now, if I have to close the channel unilaterally and the channel had a bunch of HTLCs, I can't be expected to go looking for a miner every time my transaction size is greater than 400,000 WU. The other alternative will be to run another software other than Bitcoin-Core that accepts such transactions, but that would have to also mean the miners also run this software. If miners run only Bitcoin-Core they will never receive the transactions and Bitcoin-Core nodes in between will not relay it. The best thing is to conform the Bitcoin-Core standardness as it is in the interest of all.
Where does the number 400000 come from?
Before the activation of SegWit transactions were limited to 100,000 bytes (since a long time). This was merely extended to 400,000 WU.