Opportunity or Threat: Dissecting Tensions in a Post‐Carbon Rural Transition