It will get too big one day but probably, hard drives and SSDs would be much cheaper so everyone would still be able to afford running a full node. The reason why most people don't support bigger blocks is this, people will no longer be able to run a node and only big companies will be able to so, so the network will be less decentralized and we don't want that.
It is worth adding that this is also one of the reasons why 2nd layer solutions such as Lightning Network are important approaches on solving the scalability challenge. Finding a way to move at least part of the transactions off-chain, in a secure and decentralized way, is necessary to allow for Bitcoin to scale non-linearly. Otherwise you're reduced to increasing blocksize whenever a new capacity threshold is reached, which is arguably not a viable solution.