So I think, to turn it into an apartment that meets our current standards, you will have to take quite a bit into your own hands. Bathroom and pantry are in the most unfavorable locations possible. The suggestion has already been made here: to make a modern bathroom out of the toilet, pantry, and the hallway in front of it. Turn the office into a bedroom. However, I seem to recall that the street runs past there. Then of course the question is how busy that street is...
Load-bearing walls can certainly be replaced by supports and beams, but that is already a bigger operation—and costs accordingly.
The fundamental question is: do you want to live there long-term? For example, if it is in a trendy district and the possibility exists to rent out the newly renovated apartment well if it no longer suits you, then an extensive renovation/refurbishment makes more sense. Or is it in the middle of nowhere and your family lives there and it would not be welcomed if this apartment were to be rented out to strangers? Then I would seriously consider whether the apartment, even rebuilt, will meet your standards in the long term.
For a nice old building in a good location, I would say: go for it!
But here we really know far too little about your circumstances (future planning, budget, circumstances of the "family house," etc.).
Of course something can be made of it, lines can be rerouted, everything is possible and merely a question of money.
Only: what use is a fancy design if the whole thing may cost a maximum of €100,000?