I find in practice this limitation is not an issue and column flexibility does not get in the way.
For the kinds of uses SQLite sees, the loose approach to data integrity may not have caused much grief, but I can't imagine many situations where it would have helped either.
Having support for enabling sane behaviour is welcome even if it has to be opt-in for compatibility.