The executive order seeks to limit institutional investors from purchasing single-family homes, but some market participants believe it would do little to boost housing affordability nationally.