I think 6 X 9 will be too small to anchor a dining table or a family room seating arrangement. If it were my rug, I'd put it in the sun room. It has great colors to pull from - sage, terracotta, coral, ivory and black - so looks to be a versatile piece as far as color palettes go.
You're not crazy about the rug but your husband loves it. I think it would work well in a sun room.
I don't know what your sun room looks like, but in my imagination the below would be my direction: earthy and minimalist with some curves thrown in for the sake of femininity! The agave art is by Athena Mantle. The subject matter gives a friendly nod to the rug.
Q
Love this
Q