Hiding New Posts on Front Page

You could try do something similar to the code you have tried, but using the before argument instead of the after:

$query->set( 'date_query', array(
    array(
        'before' => '-1 day', 
    )
 ) );

This way, you should get only posts published before 1 day ago.