How can I override the view selection for Main region in DXA so that I can use view from my module instead of the core view?
doesn't work for me, it still calling the view from the core area.
You need to change the Region metadata on your Component Templates to use your module region view. By default they are empty, which means they access the Core module Main region. After updating you will need to republish the pages which use these templates.