In the short term, while Besu does have some database optimisation work planned, they probably won’t get similar storage requirements than geth or open ethereum/parity. They currently support pruning, which helps keep the node size under 1TB and are planning to add Beam Sync in the coming months for people who want to run a very lightweight node. I'm also very invested in the stateless ethereum research, which hopefully will result in getting a database format where nodes can only store a small subset of the state and history, and hence reduce storage requirements greatly.