The way I (layman) understands it, BIP 174 will allow us to transfer bitcoin from a cold wallet with a "partially signed transaction" without having to immediately upload that transaction to the bitcoin network.   Meaning we can use our (supported) cold wallet for purchases and transactions while maintaining it's security.  Transactions will be fully signed at a later time.

So, essentially it can make a cold wallet partially hot.