Tidal influence on midlatitude airglow: Comparison of satellite and ground‐based observations with TIME‐GCM predictions