there is a manual override but once you are fully trimmed down manually trimming up takes time and time is something you don't have much of with the plane pitching down near the ground.
the control surfaces have less authority than the trim. original spec called for less mcas authority, but it was increased later without much consideration.