They had more chemistry than when he randomly hooked up with 7 for no reason, but that's not saying much.

Janeway didn't need a love interest. She was better off with her holo doll.

No. Let it go. It was already well, well over the shark by the end of its run. The only people left who want more have an unhealthy relationship with it and don't need enabling.

It could work tbh, but there's no point. The old end of the fandom has a rage on for anything that's not firmly inside the TNG box right now. They'll scream and shout boycott until any idea that's not "and the old guard rode in to save the day" gets tossed in the bin. They'd rather break their toy than see it regifted to a new generation. The franchise is dead.