So in future the Bitcoin Core can compress the local blockchain and eliminate all old spent transactions.
Right?
You can eliminate spent outputs yes. It's generally called blockchain pruning and there have been several discussion on this. i.e.
https://bitcointalk.org/index.php?topic=96644.0Enjoy.