That's your answer. The average home user just wants to plug in a device, type in the wifi code, and never think about it again. Only tech nerds want fiber type connectivity. Putting SFP into home devices would see that SFP sitting unused 99.9999% of the time. Why incur the expense of adding it?
At work/home you can have a docking station. Or a $20 USB hub that has a builtin ethernet adapter. Ethernet for fixed use is easy.
And it's legitimately difficult to fit an ethernet port on a typical laptop (or fragile, if you make it fold).
Of course I do understand that if you're a network engineer, you don't want to screw around with docking stations and dongles and such.
That said, if some device is simply too thin to accommodate a network port, I don't mind using an adapter through USB-C / upcoming USB4 and etc.
Exactly: All good laptops come with Ethernet ports.
Until you are looking at speeds above 10 gigabit or need to run particularly long cables (beyond 100m, which would almost never be relevant to most consumers) there is no particular need for SFP, and the added cost and complexity is beyond what most consumers want to deal with. Given that most consumer devices cannot come close to saturating a 10 gigabit link and people mostly use wireless links anyway, there is no real point in putting SFP ports in consumer devices.