Yes, it’s the normal and expected behavior of Windows. It makes sense when you are switching back and forth between spreadsheets, but because we are talking about FS and other flight support apps it would great if you could keep using the yoke or drone while the focus is on another window.
Asobo hasn’t put much thought into these details and the proof is we still have that goofy zoom behavior while turning the mouse wheel on another app.