If My I-751 is Denied, Does My Sponsor Still Need to Support Me Due to the 864 Affidavit of Support?

Yes, even if your 751 is denied, your sponsor is still obligated to support you. That obligation will likely continue unless and until you are deported.