How necessary is a dedicated office in this situation?

I WFH and plan on moving in soon with my girlfriend and her roommate. My girlfriend is disabled and currently doesn’t work, and often needs the bedroom to lie down when she isn’t feeling well. Roommate works non-remote, but her hours aren’t 9-5, typically being 7-3 or 12-8. I don’t have a call heavy job; typical day is maybe 30 minutes of calling to maybe an hour and a half on a busy day.

Obviously ideally we’d just get a 3br, so I can have a dedicated office, but we’re all close enough that we’ve agreed, if we can only budget/find a 2br, they would both be okay with me taking the dining room as an “office” for me to work from instead. This is mostly fine with me, but has anyone tried this and had it just be a disaster? One way I figure it is that the money we save getting a 2br can be invested in things like noise canceling headphones, a room divider if the dining room is open to the living room or kitchen, etc.