> Your payment would be proportional to the number of attestations, so if only a few people use ETH for transactions, your reward will be low.

Attestations are a staking consensus concept, not a transaction concept. Attestations occur 24/7, not just when people decide to use the network.