My impression is that people normally don't use Copilot as a substitute for finding solutions (ChatGPT is much better for that), but as a way to help with otherwise tedious tasks that are really specific to your codebase. Check out 6:05 and 6:25 in this Andreas Kling video for a good example: https://www.youtube.com/watch?v=8mxubNQC5O8
Regarding your second point Copilot helps me when I least expects it. I think the video illustrates what I mean with that as well.