You can’t get in without a Costco card
You can fill prescriptions as Costco without a card. Just flash your prescription at the door and tell them you want to use the pharmacy.
Costs are about 2/3rds or more less than regular drugstores.