It's possible that many of those interactions with other Office apps (and even non-MS apps) can be handled by Flows in Power Automate:So far, in the time I have worked with Access as a dabbler and later as a user for corporate and government functionality, I have never seen anything in the same price-class that had quite the utility of Access. Particularly considering the added feature of having lots of "hooks" into Excel, Word, Outlook, and other Office-class apps. Every time someone comes up with an alternative, it is sorely deficient in some way. Though Access is clunky and has many limitations when not using an active SQL back-end, nonetheless I've never seen anything that could beat it overall.
That may very well be the intention of Microsoft as you work within the MS 365 ecosystem. Including Power Apps.
I agree Access doesn't have a replacement but I think us devs are going to need to learn some new tricks to keep up with these developments.