I don't have a problem with console size personally; I never had an issue with the original Xbox or fat PS3 being bulky.
I admit, neither a PS5 nor a Series X are going to fit into my current TV cabinet, as it has just enough space for a Wii, a PS3, a 360, and a Wii U to fit comfortably side by side, and while the Wii U has been packed away now, that's obviously not enough free space for one of these beasts.
But heck, if I end up getting one I'll work something out; probably just plonk it on the floor next to the cabinet, may not look neat but who cares, I've never been a stickler for everything to look super organised. (Despite having clinical OCD, which unlike what the media portrays often has nothing to do with wanting things tidy)
While I find it interesting from a design point of view, size just isn't really a factor for me and certainly doesn't make a console less appealing.