Function of BIP 174 is helping to make and sign block-to-block transaction. This is built for compatibilities client-to-client. And also make possible easier hardware wallet and offline wallet setting.
So BIP 174 is not protocol or layer 2 solution for off chain transaction but BIP 174 is a transaction format for a transaction that not ready to broadcast to the bitcoin network.