True-75-ohm BNC connectors are mechanically compatible with 50 ohm BNC connectors. This is not true for type-N connectors, where the 50 and 75 ohm versions are not compatible.
Most BNC connectors for RG-59/U 75 ohm coaxial cable are actually 50 ohm BNCs, but with cable-interface dimensions to work with RG-59/U. The short length of mismatched line through the connector is only important at relatively high frequencies. The cable length in a mismatched system may be important, since it is much longer.
For applications at frequencies where the cable length is short compared with the wavelength, the foam-dielectric "low-loss" RG-59 variants have less capacitance per unit length than the solid-dielectric cables, which can be useful. High-voltage coaxial connectors of similar size to BNC (e.g., MHV and SHV) usually use RG-59/U for a few kilovolts of DC. The foam-dielectric cables are not appropriate (I learned the hard way) for that application. In grad school, we replaced the MHV panel connectors on photomultiplier power supplies with SHV, since a determined student could mate a BNC plug with the MHV panel connector, with possible damage and insufficient voltage rating.