First, create a page with the intended URL slug and note down the ID of it. Then in your functions.php
function wpse410694_custom_redirect() {
//Let us assume the ID of the page is 123
if ( is_page(123) ) {
wp_redirect( 'drive.google.com/myCustomPDF_Link' );
exit;
}
}
add_action( 'template_redirect', 'wpse410694_custom_redirect');
The maximum upload size is normally set from server. You can increase it by tweaking the server settings.