Clickbait. This is not a problem, non steam games simply won't have steam features, the gamepad will work normally just as well... Just like any other controller would.
The new Steam Controller costs $99, but it is closely tied to Steam Input. This could cause problems with Game Pass titles in particular. Possible solutions are already being discussed on Reddit.