With HUB2’s kind help this solution finally worked! Thanks a ton HUB2!
<?php
$term_id = get_queried_object()->term_id;
$post_id = 'product_cat_'.$term_id;
$custom_field = get_field('custom_category_content', $post_id); // My Advanced Custom Field Variable
?>
<div><?php echo $custom_field; ?> </div> <?php // Get Advanced Custom Field Value ?>
