Andromeda was just a complete mess. Never had any direction mechanically and the narrative was in a complete lurch. The "procedural generated" bullshit didn't work out so all the planets were just empty husks. Think ME1 side missions, except it was supposed to be the bulk of the game. Pair that with them being scared shitless to make any sort of statement about their disaster of an ending that was ME3 and it was just sort of a game that was unfulfilling to everyone.
As far as the series going forward, if they truly are going to try to marry Andromeda and the original trilogy, good luck. It's just in that funky place where they don't have a lot to work with. Plenty of people just probably want to leave the series as is.
On the PC you can mod the ending of the trilogy to be, at best, an inconsistent romp that ends with the citadel DLC. It's far more palatable than it was in ol March of 2012. Then you have Andromeda which, despite adding a fun spin on the combat, the game itself was just a mess technically and felt rushed despite its long dev time. Compile those warts with the fact that its story really wasn't impressive and you have to ask yourself, is there anything worth salvaging from that game? BioWare is gonna try to force something here and I don't think they have the talent to pull it off anymore.
HOWEVER, if they really are gonna try to make the destroy ending canon and give me another chance to explore one of my favorite fictional universes of all time, then I'll definitely be monitoring the development of the game for sure.