Applied at car company for content creator

I recently found myself reflecting on a job offer I turned down three months ago for a content creator position at a car company (Job C). At the time, I was working in a sportswear company (Job A) where I felt stuck due to limited advancement opportunities and a tight budget that restricted my projects. Job C had promised more control over my work and better advancement prospects, but it also came with a heavier workload. When I received the offer from Job C, it matched my current salary at Job A, but Job A responded with a counteroffer that almost matched the upper salary of Job C, along with future promises of promotions. Feeling valued at Job A, I decided to decline Job C's offer, which seemed to frustrate them. They even arranged a meeting to discuss my concerns, but I ultimately chose to politely decline and suggested they consider other candidates. Now, looking back, I regret my decision. Job C did not hire anyone for the position and instead brought back a former employee as a freelancer. I'm contemplating reaching out to them to see if the position is still available. My partner thinks I should stay put, fearing it might be a case of 'the grass is greener,' but I feel like I missed an opportunity. Should I email them to inquire about the job?