We did warn then it was a bad idea. Other countries especially countries in Eastern EU warned them it was a bad idea. And lo and behold trying to bring peace through trade didn't work with Russia.
Unless Germany wants to exit the EU like the UK it does have to take the interests of other EU countries into account, many of them are much more anti Russia then America for obvious reasons. And even if Germany were to leave, not sanctioning Russia now would still be bad even if only considering German interests