Date fields in ACF are not stored in standard SQL date format, which is seems you are aware of looking at this line of your code $today = date('Ymd');
and this is the reason your query is getting no results. Change the type of the meta field to either ‘NUMERIC’ or let it default to ‘CHAR’.