I wanted to stay in Venice for a few days on a recent solo trip, and Theresa and Kris' place was great for a cozy WFH spot and Venice adventuring spot. While my trips were limited to walkable spots, there are bikes for a pair to explore the beaches and beyond.
I do think it would be a bit tight for two people unless you were out often. For one person who had to work a bit, it worked like a charm.