Yeah, I'm afraid you blew it. Right idea, wrong base.
Paint is made in several levels of base. A white base which has lots and lots of white tint, and is intended to have small amounts of color added, to ultimately create an off-white. A medium base has less white tint and is intended to make more colorific colors like pastels (most architectural coatings are pastels or off-whites). And a deep base has no white tint at all, and is intended to be entirely colored by the squirts of color from the tinting machine. This is to allow deep and high-impact colors such as
What's more, deep bases are expected to use a lot of squirts of pigment from the carousel. Those pigments aren't cheap, so they up the price on the assumption they'll be giving you a lot of pigment. Also, they leave extra room in the can for all that pigment, so to add insult to injury, you get less paint.
So what you have there is effectively varnish.
How do you fix it? Well, you may notice that the pigment carousel at the hardware store doesn't have any white pigment. The white pigment comes in the white or medium base cans. It is not possible for the paint shop to turn a deep base into white.
You might try buying some titanium dioxide pigment and seeing if you can pigment-load the base. It's not terribly expensive; it's worth some experimentation. Since you are only using one pigment, there's a fair chance the colors will match even with different ratios of base to pigment.
Your other option is to buy a gallon or quart of the same stuff, and measure exactly how much paint is actually in the can. Then meter out your 5-gal., putting exactly that much paint into new cans. They should be able to tint that, but it'll have to be a bold color.
... And in the future, even out your surfaces with primer. It's designed to make unequal surfaces equal... and it's cheaper. Use primer to prevent bleed-through, not paint.