In order to unlcok Auction House in NBA 2K24, you need to collect 30 cards. This is a Lifetime Agenda(Collector Level).
You have obtained 30 cards. Now, you can view your Lifetime Agenda and the Auction House will be unlocked immediately.