It will probably be confusing, but no they don't have to match, nor does North always have to be the top of the page, but that is the general expectation. Going against that will already be slightly confusing, having an inset map set at 90 degrees from the other will be doubley so. I can see setting an inset map at a slightly different angle like 5 or ten degrees but more than that would be weird. I'd say draw you main map horizontal as you wish, with north going to the right or left and put the inset and turn it accordingly. Or you can draw a sort of doobaly doo showing that its a blown up area and also that is turned. but that seems more difficult to convey.