Yes, but only cloud streaming titles (of which there aren’t many) and the also (few) online-only competitive shooters and MMOs.

There are no Switch games that run locally that lock single player away if you’re not connected.