the reason people are not using bitcoin core is the over 300 gigabyte of data needed to download the full blockchain while people prefer not to run the pruned version but the full client.
It is not only about big storage space requirement for a full node and the cons of prune node, but also about the decreased capacity of your computer when you start it and let your full node runs. The full node operations do slow down the general performance of your computer.
I tried it in the past and above is my experience. So except only when you are using a superb strong computer, you will get inconvenience if you are working on the same computer that stores and runs the full node.
I will focus more on simple payment verification (SPV) wallets because they are the ones used by people commonly today.
SPV ~
Simplified payment verification. Simplified,
not simple. They are lightweight client wallet.
Some nodes maintain only a subset of the blockchain and verify transactions using a method called simplified payment verification, or SPV. These nodes are known as SPV nodes or lightweight nodes.
[1]
https://en.wikipedia.org/wiki/Bitcoin[2]
Mastering bitcoin - Chapter 5, The Bitcoin network