It's nothing really new and the same dynamics can be observed throughout history. Imagine there was a time one could look over and see the bay without the Golden Gate bridge or high rise buildings. And now, its even an iconic thing!
A generation or two in the future astronomy will probably get redefined quite a bit via remote telescopes and adventure vacations to space and so forth.
Even now there are plenty of enthusiasts who are excited to take pictures of rockets during take off or explore satellites as they pass by. So it actually get more people interested in space and astronomy.
And there will always be people on either side supporting or opposing technological advances - as we have seen thought history. The one thing that is certain in my opinion though is that things will change.