IBuyers like Opendoor and Offerpad once appeared poised to be an essential player in the nation's biggest housing markets. Now, real estate agents say their role has diminished dramatically.