A 18-year veteran like OP shouldn't be complaining about their manager's lack of vision ; they should have realised by now that it's also their job to enact the vision. He was probably paid too much to behave as a passenger.
It would take close to a decade to align these products.
My impression is that this is a place to hang these products on the org-tree. IMO the individual teams appear to have LOTS of vision!
The VP in question is unnecessary (IMO).