Store only a resized version of an enormous uploaded image
Yes, that functionality is in Drupal core as default.

In Image field settings (your Content type -> Manage fields) set for Maximum image resolution to 800x800px. Drupal will resize image size and save only resized version of it.