When you get right down to most issues are principally moral v moral or moral v cash, guns, abortions, drugs, porn, prostitution, gay rights, etc are mostly moral v moral, whereas military spending, environmentalism, welfare, SS, etc are moral v cash. Moral v moral issue rarely have much to do with each other and moral v cash are mostly about priority and efficiency. Liberal and conservative are pretty vague and silly concepts, depending on who you ask inside the GOP I am a moderate establishment republican or an arch-conservative or libertarian and you'll get that from people who have equal knowledge of my political leanings. Same applies to the left. Most people have a few pet issues and they connect them together into their pet uber-ideology, I count myself lucky to have mostly avoided that trap, mostly because I know there's an alternate Universe nearly identical to ours where pot didn't get banned and right now the Dems are screaming about the republicans "Taking blood money from the NRA, Phillip-Morris, and High Times" and another where the republicans are accusing the left of trying to starve children.

So no I don't really think a social liberal fiscal hawk is in the cards mostly because the former is something I don't believe exists and the latter is one I view as a matter more associated to how frugal someone is, which really has nothing to do with their abortion or gun stance, but it does have a lot to do with how likely someone is to agree to additional funding for various programs especially those that hinge on giving individuals cash. Your average frugal person if asked to define 'poverty level' is likely to give a lower value than the average person. As long as socially liberal includes, in people's eyes, issues that are more moral v cash as opposed to principally moral v moral, fiscal conservatives are likely to be rarer animals in that group then out. Frugal people usually deny themselves a lot of luxuries and tend to get irritated, unsympathetic, or even outraged by those who don't especially on the taxpayer dime. Forget your wallet or be low on cash some week, go out for dinner with a frugal friend and they don't just order cheap they'll typically get angry if you spend the borrowed cash on steak, even if the amount you borrowed didn't bother them at all and they have no doubt you're good for it. This is a great mindset for people in public office to have, especially with money that isn't theirs, but it doesn't tend to lend itself as readily raising taxes to increase payments to the poor.

If you redefine social liberal to be only those things which are moral v moral issues, then yeah, it can happen and probably would. We've had times like that before, it will probably happen again.