It’s true that onchain usage is stagnating. But it keeps evolving. Ark and Spark are scaling while using onchain. Even lightning is on one hand reducing the need of many onchain transaction but creating dependency on it at the same time.
Nobody knows what is the reasonable security budget. Maybe it’s still too big.