Why can’t publish posts with too much text?

If you look into LONGTEXT documentation you’ll see that:

The effective maximum length of LONGTEXT columns also depends on the
configured maximum packet size in the client/server protocol and
available memory.

So I would say that 4GB support is only theoretical, in real life your server configuration wouldn’t allow operating on such a big chunk of data in one DB field, especially if it’s a shared hosting solution.