Characterizing flow behavior for gas injection: Relative permeability of CO2‐brine and N2‐water in heterogeneous rocks